Re: Hot standby and removing VACUUM FULL - Mailing list pgsql-hackers

From Greg Smith
Subject Re: Hot standby and removing VACUUM FULL
Date
Msg-id 4B084061.5030901@2ndquadrant.com
Whole thread Raw
In response to Hot standby and removing VACUUM FULL  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: Hot standby and removing VACUUM FULL
List pgsql-hackers
Heikki Linnakangas wrote:
> So I guess what I'm asking is: Does anyone see any show-stoppers in
> removing VACUUM FULL
Here's the disclaimers attached to the new VACUUM REPLACE implementation 
from Itagaki:

"We still need traditional VACUUM FULL behavior for system catalog 
because we cannot change relfilenode for them. Also, VACUUM FULL REPLACE 
is not always better than traditional VACUUM FULL; the new version 
requires additional disk space and might be slower if we have a few dead 
tuples."

That first part seems like it would limit the ability to completely 
discard the current behavior.

-- 
Greg Smith    2ndQuadrant   Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com  www.2ndQuadrant.com



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Proposal: USING clause for DO statement
Next
From: Tom Lane
Date:
Subject: Re: Proposal: USING clause for DO statement