Re: Autovacuum / full vacuum

From: Michael Riess <mlriess(at)gmx(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Autovacuum / full vacuum
Date: 2006-01-17 14:05:29
Message-ID: dqitj2$27j3$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> VACUUM FULL blocks the application. That is NOT something that anyone
> wants to throw into the "activity mix" randomly.

There must be a way to implement a daemon which frees up space of a
relation without blocking it too long. It could abort after a certain
number of blocks have been freed and then move to the next relation.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew T. O'Connor 2006-01-17 14:09:02 Re: Autovacuum / full vacuum
Previous Message Christopher Browne 2006-01-17 14:04:06 Re: Autovacuum / full vacuum