Postgres Pro
Downloads
Home   >   mailing lists

Re: VACUUM FULL out of memory - Mailing list pgsql-hackers

From Holger Hoffstaette
Subject Re: VACUUM FULL out of memory
Date
Msg-id pan.2008.01.07.16.33.53.25750@wizards.de
Whole thread Raw
In response to VACUUM ANALYZE out of memory  (Michael Akinde <michael.akinde@met.no>)
Responses Re: VACUUM FULL out of memory  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
Tree view 
On Mon, 07 Jan 2008 10:57:53 -0500, Andrew Sullivan wrote:

> Note that you should almost never use VACUUM FULL unless you've really
> messed things up.  I understand from the thread that you're just testing
> things out right now.  But VACUUM FULL is not something you should _ever_
> need in production, if you've set things up correctly.

Then why does it exist? Is it a historical leftover? If it is
only needed for emergency, should it not have a different name?
Just curious..

Holger

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Bug: Unreferenced temp tables disables vacuum to update xid
Next
From: "Joshua D. Drake"
Date:
Subject: Re: VACUUM FULL out of memory