Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: jd.vcf
Description: text/x-vcard (640 bytes)

In response to

Responses

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group