Re: Autovacuum / full vacuum

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Autovacuum / full vacuum
Date: 2006-01-17 13:59:28
Message-ID: m364ojrm4f.fsf@mobile.int.cbbrowne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!"

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Browne 2006-01-17 14:04:06 Re: Autovacuum / full vacuum
Previous Message Markus Schaber 2006-01-17 13:52:58 Re: new to postgres (and db management) and performance