> 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.
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
Description: text/x-vcard (640 bytes)
In response to
pgsql-general by date
|Next:||From: Tom Lane||Date: 2004-11-29 20:26:09|
|Subject: Re: VACUUM and ANALYZE Follow-Up |
|Previous:||From: Woodchuck Bill||Date: 2004-11-29 20:01:26|
|Subject: Re: PGSQL: The Gateway will be kept.|