Re: Autovacuum / full vacuum

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Riess <mlriess(at)gmx(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Autovacuum / full vacuum
Date: 2006-01-17 15:13:41
Message-ID: 28349.1137510821@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Michael Riess <mlriess(at)gmx(dot)de> writes:
> I'm curious as to why autovacuum is not designed to do full vacuum.

Locking considerations. VACUUM FULL takes an exclusive lock, which
blocks any foreground transactions that want to touch the table ---
so it's really not the sort of thing you want being launched at
unpredictable times.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Sullivan 2006-01-17 15:13:57 Re: Autovacuum / full vacuum
Previous Message hubert depesz lubaczewski 2006-01-17 15:10:34 Re: Autovacuum / full vacuum