Horton

Re: [HACKERS] More detail on settings for pgavd?

Shridhar Daithankar <shridhar_daithankar@myrealbox.com>

View thread View on postgr.es
From: Shridhar Daithankar <shridhar_daithankar@myrealbox.com>
To: "Matthew T. O'Connor" <matthew@zeut.net>
Cc: Josh Berkus <josh@agliodbs.com>, Shridhar Daithankar <shridhar_daithankar@myrealbox.com>, pgsql-performance@postgresql.org, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2003-11-21T15:06:54Z
Lists: pgsql-hackers, pgsql-performance 
Matthew T. O'Connor wrote:

> But we track tuples because we can compare against the count given by 
> the stats system.  I don't know of a way (other than looking at the FSM, 
> or contrib/pgstattuple ) to see how many dead pages exist.

I think making pg_autovacuum dependent of pgstattuple is very good idea.

Probably it might be a good idea to extend pgstattuple to return pages that are 
excessively contaminated and clean them ASAP. Step by step getting closer to 
daemonized vacuum.

  Shridhar