Horton

Re: Very poor estimates from planner

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rod Taylor <rbt@rbt.ca>
Cc: Scott Marlowe <scott.marlowe@ihs.com>, PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2003-11-05T23:57:04Z
Lists: pgsql-hackers 
Rod Taylor <rbt@rbt.ca> writes:
>> I'm not sure if that will actually change the default_statistics_target

> Hmm.. I was under the impression that it would work for any tables that
> haven't otherwise been overridden.

It will.  I think Scott is recalling the original circa-7.2
implementation, where it wouldn't.  If you're unsure that you
affected it, check out the actual sizes of the array values in pg_stats.

			regards, tom lane