Re: [HACKERS] Autovacuum Improvements - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: [HACKERS] Autovacuum Improvements
Date
Msg-id 20070121134410.GB2123@svana.org
Whole thread Raw
In response to Re: [HACKERS] Autovacuum Improvements  ("Simon Riggs" <simon@2ndquadrant.com>)
List pgsql-general
On Sun, Jan 21, 2007 at 12:24:38PM +0000, Simon Riggs wrote:
> Partial vacuum would still be possible if you remembered where you got
> to in the VACUUM and then started from that same point next time. It
> could then go to the end of the table and wrap back around.

ISTM the Dead Space Map would give you this automatically, since that's
your memory... Once you have the DSM to track where the dead pages are,
you can set it up to target clusters first, thus giving maximum bang
for buck.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: "Mike Poe"
Date:
Subject: Replicating Binary Data from MS SQL 2000 to PG 8.2
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Using transactions with plpythonu