Re: VACUUM and ANALYZE Follow-Up

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Mark Dexter <MDEXTER(at)dexterchaney(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: VACUUM and ANALYZE Follow-Up
Date: 2004-11-29 20:08:28
Message-ID: 41AB81BC.5090409@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Attachment Content-Type Size
jd.vcf text/x-vcard 640 bytes

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-11-29 20:26:09 Re: VACUUM and ANALYZE Follow-Up
Previous Message Woodchuck Bill 2004-11-29 20:01:26 Re: PGSQL: The Gateway will be kept.