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

From Jeff Davis
Subject Re: Feedback on getting rid of VACUUM FULL
Date
Msg-id 1253136562.29243.348.camel@monkey-cat.sm.truviso.com
Whole thread Raw
In response to Re: Feedback on getting rid of VACUUM FULL  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
On Wed, 2009-09-16 at 23:53 +0300, Heikki Linnakangas wrote:
> For the kicks, I looked at what it would take to write a utility like
> that. It turns out to be quite trivial, patch attached. It uses the same
> principle as VACUUM FULL, scans from the end, moving tuples to
> lower-numbered pages until it can't do it anymore. It requires a small
> change to heap_update(), to override the preference to store the new
> tuple on the same page as the old one, but other than that, it's all in
> the external module.

It fails at initdb time for me:
FATAL:  unrecognized heap_update status: 5
STATEMENT:  REVOKE ALL on pg_authid FROM public;

Regards,Jeff Davis



pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Feedback on getting rid of VACUUM FULL
Next
From: Josh Berkus
Date:
Subject: Re: PATCH: make plpgsql IN args mutable (v1) [REVIEW]