Re: Autovacuum / full vacuum - Mailing list pgsql-performance

From Christopher Browne
Subject Re: Autovacuum / full vacuum
Date
Msg-id m364ojrm4f.fsf@mobile.int.cbbrowne.com
Whole thread Raw
In response to Autovacuum / full vacuum  (Michael Riess <mlriess@gmx.de>)
Responses Re: Autovacuum / full vacuum
List pgsql-performance
> I'm curious as to why autovacuum is not designed to do full vacuum.

Because that's terribly invasive due to the locks it takes out.

Lazy vacuum may chew some I/O, but it does *not* block your
application for the duration.

VACUUM FULL blocks the application.  That is NOT something that anyone
wants to throw into the "activity mix" randomly.
--
let name="cbbrowne" and tld="gmail.com" in String.concat "@" [name;tld];;
http://linuxdatabases.info/info/slony.html
Signs of a Klingon Programmer #11: "This machine is a piece of GAGH! I
need dual Pentium processors if I am to do battle with this code!"

pgsql-performance by date:

Previous
From: Markus Schaber
Date:
Subject: Re: new to postgres (and db management) and performance
Next
From: Michael Riess
Date:
Subject: Re: Autovacuum / full vacuum