Re: VACUUM FULL out of memory

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Mon, 07 Jan 2008 17:33:53 +0100
"Holger Hoffstaette" <holger@wizards.de> wrote:

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

There are times when it is required, usually when people don't
configure normal vacuum/autovacuum correctly.

Sincerely,

Joshua D. Drake

> 
> Holger
> 
> 
> 
> ---------------------------(end of
> broadcast)--------------------------- TIP 4: Have you searched our
> list archives?
> 
>                http://archives.postgresql.org
> 


- -- 
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ 
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD'


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHgmEbATb/zqfZUUQRAoyXAJ9GB4lXGr6UsEMpdT4KDvtIkRv+ywCdEMQV
T07KuT+OUWcrr9NEX+blSuQ=
=rDNL
-----END PGP SIGNATURE-----