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

Re: VACUUM and ANALYZE Follow-Up

From: Mage <mage(at)mage(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: VACUUM and ANALYZE Follow-Up
Date: 2004-11-29 23:34:02
Message-ID: 41ABB1EA.50101@mage.hu (view raw or flat)
Thread:
Lists: pgsql-general
Joshua D. Drake wrote:

>>
>> 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.

Every 5th page of the manual says that I should use vacuum analyze 
frequently. There are two command line tools for this and another one in 
the contrib. I think none of them cares of empty tables.

This issue need to be fixed.

       Mage

In response to

Responses

pgsql-general by date

Next:From: Joshua D. DrakeDate: 2004-11-30 01:02:21
Subject: Re: VACUUM and ANALYZE Follow-Up
Previous:From: Alvaro HerreraDate: 2004-11-29 23:09:25
Subject: Re: VACUUM and ANALYZE Follow-Up

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