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

From Michael Riess
Subject Re: Autovacuum / full vacuum
Date
Msg-id dqitj2$27j3$1@news.hub.org
Whole thread Raw
In response to Re: Autovacuum / full vacuum  (Christopher Browne <cbbrowne@acm.org>)
Responses Re: Autovacuum / full vacuum
List 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.

pgsql-performance by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Autovacuum / full vacuum
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: Autovacuum / full vacuum