Re: VACUUM and ANALYZE Follow-Up - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: VACUUM and ANALYZE Follow-Up
Date
Msg-id 20041129232130.B633@hermes.hilbert.loc
Whole thread Raw
In response to Re: VACUUM and ANALYZE Follow-Up  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
> >In any case, it is hard to see how the present behaviour can be seen as
> >desirable.  It obviously causes problems at least for new Postgres
> >users, and we
> >all hope there will be many more of these folks in the future.  Thanks
> >for considering this.  Mark
>
> Uhmmm... analyze or vacuum on an empty table is fairly pointless. Those
> utilities are supposed to be used on tables that have data.
>
> So the answer is, use them on tables that have data.
What the OP seems to be saying is that to him it would make a
lot of sense to have vacuum by default not act on empty
tables.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: Gary Doades
Date:
Subject: Re: USENET vs Mailing Lists Poll ...
Next
From: "Mark Dexter"
Date:
Subject: Re: VACUUM and ANALYZE Follow-Up