Re: Feedback on getting rid of VACUUM FULL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Feedback on getting rid of VACUUM FULL
Date
Msg-id 3999.1253151325@sss.pgh.pa.us
Whole thread Raw
In response to Re: Feedback on getting rid of VACUUM FULL  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Feedback on getting rid of VACUUM FULL
Re: Feedback on getting rid of VACUUM FULL
List pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> The way I read the thread so far is that there are multiple
> requirements:

> * Shrink a table efficiently - when time and space available to do so

To be addressed by the CLUSTER-based solution (VACUUM REWRITE or
whatever we call it).

> * Shrink a table in place - when no space available

To be addressed by the UPDATE-style tuple-mover (which could be thought
of as VACUUM FULL rewritten to not use any special mechanisms).

> * Shrink a table concurrently - when no dedicated time available

Wishful thinking, which should not stop us from proceeding with the
solutions we know how to implement.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Feedback on getting rid of VACUUM FULL
Next
From: Robert Haas
Date:
Subject: Re: Feedback on getting rid of VACUUM FULL