Horton
Menu

Re: Autovacuum / full vacuum

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael Riess <mlriess@gmx.de>
Cc: pgsql-performance@postgresql.org
Date: 2006-01-17T15:13:41Z
Lists: pgsql-performance 
Michael Riess <mlriess@gmx.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