Horton

Re: sub select performance due to seq scans

Markus Schaber <schabi@logix-tt.com>

View thread View on postgr.es
From: Markus Schaber <schabi@logix-tt.com>
To: pgsql-performance@postgresql.org
Cc: H Hale <hhale21@rogers.com>
Date: 2006-08-07T13:32:39Z
Lists: pgsql-performance 
Hi, Scott and Hale,

Scott Marlowe wrote:
> Make sure analyze has been run and that the statistics are fairly
> accurate.

It might also help to increase the statistics_target on the column in
question.

HTH,
Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org