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

From Ron Mayer
Subject Re: Feedback on getting rid of VACUUM FULL
Date
Msg-id 4AB175EB.8030206@cheapcomplexdevices.com
Whole thread Raw
In response to Re: Feedback on getting rid of VACUUM FULL  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas wrote:
> Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> wrote:
>> Hannu Krosing wrote:
>>> On Wed, 2009-09-16 at 21:23 +0300, Heikki Linnakangas wrote:
>>>> 2) Another utility that does something like UPDATE ... WHERE ctid > ? to
> I also wonder whether we should consider teaching regular VACUUM to do
> a little of this every time it's run.  Right now, once your table gets

Having it be built into VACUUM would surprise me a bit, but I wonder
if autovacuum could detect when such a tuple-mover would be useful,
and run one before it does a VACUUM if needed.




pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Hot Standby 0.2.1
Next
From: Tom Lane
Date:
Subject: Re: PATCH: make plpgsql IN args mutable (v1) [REVIEW]