Re: sub select performance due to seq scans

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: H Hale <hhale21(at)rogers(dot)com>
Subject: Re: sub select performance due to seq scans
Date: 2006-08-07 13:32:39
Message-ID: 44D740F7.2020204@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Arjen van der Meijden 2006-08-07 13:45:08 Re: PostgreSQL scalability on Sun UltraSparc T1
Previous Message Markus Schaber 2006-08-07 13:18:27 Re: PostgreSQL scalability on Sun UltraSparc T1