Re: pre-Vacuum statistics

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Rich Cullingford <rculling(at)sysd(dot)com>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: pre-Vacuum statistics
Date: 2003-07-11 10:57:47
Message-ID: 1057921066.46100.157.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Cain 2003-07-11 13:17:40 Re: force the use of a particular index
Previous Message Rod Taylor 2003-07-11 10:55:59 Re: Dual Xeon + HW RAID question