Postgres Pro
Downloads
Home   >   mailing lists

Re: sub select performance due to seq scans - Mailing list pgsql-performance

From Markus Schaber
Subject Re: sub select performance due to seq scans
Date
Msg-id 44D740F7.2020204@logix-tt.com
Whole thread Raw
In response to Re: sub select performance due to seq scans  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Markus Schaber
Date:
Subject: Re: PostgreSQL scalability on Sun UltraSparc T1
Next
From: Arjen van der Meijden
Date:
Subject: Re: PostgreSQL scalability on Sun UltraSparc T1