Re: Self-generating statistics?

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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110