Re: Very poor estimates from planner - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: Very poor estimates from planner
Date
Msg-id 1068076006.53233.4.camel@jester
Whole thread Raw
In response to Re: Very poor estimates from planner  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: Very poor estimates from planner
List pgsql-hackers
> I'm not sure if that will actually change the default_statistics_target of
> the tables you're analyzing, I think it will only apply to newly created
> tables.
>
> I believe you have to alter table alter column set statistics 1000 for
> each column you want a statistic of 1000.  You might wanna try starting
> with 50 or 100 and see if that works first.

Hmm.. I was under the impression that it would work for any tables that
haven't otherwise been overridden.
       Sets the default statistics target for table columns that have       not had a column-specific target set via
ALTERTABLE SET       STATISTICS. Larger values increase the time needed to do       ANALYZE, but may improve the
qualityof the planner's estimates.       The default is 10. 

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Open Issues for 7.4
Next
From: Tom Lane
Date:
Subject: Re: Very poor estimates from planner