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

From Joshua D. Drake
Subject Re: VACUUM and ANALYZE Follow-Up
Date
Msg-id 41AB81BC.5090409@commandprompt.com
Whole thread Raw
In response to VACUUM and ANALYZE Follow-Up  ("Mark Dexter" <MDEXTER@dexterchaney.com>)
Responses Re: VACUUM and ANALYZE Follow-Up
Re: VACUUM and ANALYZE Follow-Up
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.

Sincerely,

Joshua D. Drake



>


--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Attachment

pgsql-general by date:

Previous
From: "Mark Dexter"
Date:
Subject: VACUUM and ANALYZE Follow-Up
Next
From: Tom Lane
Date:
Subject: Re: VACUUM and ANALYZE Follow-Up