Re: possible vacuum improvement? - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: possible vacuum improvement?
Date
Msg-id GNELIHDDFBOCMGBFGEFOIEAOCEAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: possible vacuum improvement?  ("Matthew T. OConnor" <matthew@zeut.net>)
Responses Re: possible vacuum improvement?
List pgsql-hackers
> I have been doing some poking around with this item, and I was
> planning on
> using the stats collector to do "intelligent" auto-vacuuming.  I
> was planning
> on adding some new columns that account for activity that has taken place
> since the last vacuum.  The current stats collector shows n_tup_ins,
> n_tup_upd and n_tup_del for any given rel, but those numbers have
> nothing to
> do with what has happened since the last vacuum, hence nothing to do with
> current status or need for vacuum.

Postgres 7.3-beta has a new function 'pg_stat_reset()' that you can call to reset the stats collector after a vacuum...

Chris



pgsql-hackers by date:

Previous
From: "Matthew T. OConnor"
Date:
Subject: Re: possible vacuum improvement?
Next
From: "Matthew T. OConnor"
Date:
Subject: Re: possible vacuum improvement?