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

From Tom Lane
Subject Re: Autovacuum / full vacuum
Date
Msg-id 28349.1137510821@sss.pgh.pa.us
Whole thread Raw
In response to Autovacuum / full vacuum  (Michael Riess <mlriess@gmx.de>)
List 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

pgsql-performance by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Autovacuum / full vacuum
Next
From: Andrew Sullivan
Date:
Subject: Re: Autovacuum / full vacuum