Re: [HACKERS] More detail on settings for pgavd? - Mailing list pgsql-performance

From Shridhar Daithankar
Subject Re: [HACKERS] More detail on settings for pgavd?
Date
Msg-id 3FBE2A0E.3010308@myrealbox.com
Whole thread Raw
In response to Re: [HACKERS] More detail on settings for pgavd?  ("Matthew T. O'Connor" <matthew@zeut.net>)
Responses Re: [HACKERS] More detail on settings for pgavd?
List 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


pgsql-performance by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: [HACKERS] More detail on settings for pgavd?
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: [HACKERS] More detail on settings for pgavd?