On Sun, Mar 1, 2009 at 4:32 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> What do you have default_statistics_target set to? If it's less than
> 100, you should probably raise it to 100 and re-analyze (the default
> value for 8.4 will be 100, but for 8.3 and prior it is 10).
Changing it to 100 fixed the problem. Thanks for alerting me to the
existence of default_statistics_target.
In response to
pgsql-performance by date
|Next:||From: Mario Splivalo||Date: 2009-03-30 14:07:51|
|Subject: Forcing seq_scan off for large table joined with tiny table yeilds
|Previous:||From: Matthew Wakeling||Date: 2009-03-30 10:26:03|
|Subject: Re: Very specialised query|