Re: Autovacuum Improvements - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Autovacuum Improvements
Date
Msg-id 20061220011819.GV3036@alvh.no-ip.org
Whole thread Raw
In response to Re: Autovacuum Improvements  (Glen Parker <glenebob@nwlink.com>)
Responses Re: Autovacuum Improvements  (Glen Parker <glenebob@nwlink.com>)
List pgsql-general
Glen Parker wrote:

> I'd also like to use some of this information to issue reindex and
> cluster commands only when they're needed.  In fact, on days when I
> cluster, there's no need whatsoever to also vacuum those tables.  This
> is something that autovacuum won't do at all.

Well, I'd rather fix CLUSTER so that it reports that there are currently
no dead tuples in the table.  This should be an easy patch that, hey,
maybe you could contribute ;-)

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Matthew O'Connor
Date:
Subject: Re: Autovacuum Improvements
Next
From: Stephen Frost
Date:
Subject: Re: postgres kerberos how to