Re: Self-generating statistics? - Mailing list pgsql-performance

On Mon, Oct 21, 2002 at 08:23:33AM +0200, Mario Weilguni wrote:
> Something that might be worth considering:
>
> Many of the performance problems on pgsql-general seem to be
> related to the fact that no analyze is performed after the creation
> on the tables, so maybe this might be an option to fix that (in
> future releases): when a table has no statistics at all, and the
> first seq-scan on the table is

It's never the case that a table has no statistics at all.  It has
default ones.  Maybe they're right; it's hard to know.

Someone has posted on gborg an anto-vacuum daemon that might be of
use in this situation.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110