Re: pre-Vacuum statistics - Mailing list pgsql-performance

From Rod Taylor
Subject Re: pre-Vacuum statistics
Date
Msg-id 1057921066.46100.157.camel@jester
Whole thread Raw
In response to pre-Vacuum statistics  (Rich Cullingford <rculling@sysd.com>)
List pgsql-performance
On Thu, 2003-07-10 at 18:19, Rich Cullingford wrote:
> Greetings,
> All the recommendations I can locate concerning the use of (the various
> flavors of) VACUUM suggest running it at regular intervals. Is there any
> way, for a given table, to discover how many/what percentage of rows are

Not nicely, but you may want to look at pg_autovacuum either off gborg
or in the 7.4 /contrib/pg_autovacuum directory.

It will fire off a periodic vacuum based on table activity from the
statistics system.

Attachment

pgsql-performance by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Dual Xeon + HW RAID question
Next
From: Rod Taylor
Date:
Subject: Re: force the use of a particular index