Re: Very poor estimates from planner

Rod Taylor <rbt@rbt.ca>

From: Rod Taylor <rbt@rbt.ca>
To: Scott Marlowe <scott.marlowe@ihs.com>
Cc: PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2003-11-05T23:46:47Z
Lists: 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 ALTER TABLE SET
        STATISTICS. Larger values increase the time needed to do
        ANALYZE, but may improve the quality of the planner's estimates.
        The default is 10.