Gaetano Mendola <mendola(at)bigfoot(dot)com> writes:
> it seems that a vacuum full on the whole DB is more aggressive.
It is not.
A much more plausible theory is that this is the result of concurrent
changes to the table. It is clear from the "dead row versions" stats
that there were concurrent transactions ...
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Gaetano Mendola||Date: 2004-10-18 00:49:52|
|Subject: Re: Single table vacuum full different when vacuum full the whole|
|Previous:||From: Gaetano Mendola||Date: 2004-10-18 00:09:36|
|Subject: Single table vacuum full different when vacuum full the whole database|