Re: Very poor estimates from planner

On Wed, 5 Nov 2003, Rod Taylor wrote:

> Since this is a large query, attachments for the explains / query.
>
> Configuration:
> dev_iqdb=# select version();
> version
> ------------------------------------------------------------------------
> PostgreSQL 7.4beta1 on i386-portbld-freebsd4.7, compiled by GCC
> 2.95.4
> (1 row)
>
> SET default_statistics_target = 1000;
> ANALYZE;
> set from_collapse_limit = 100;
> set join_collapse_limit = 20;

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.