From: | Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com> |
---|---|
To: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com>, pgsql-performance(at)postgresql(dot)org, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] More detail on settings for pgavd? |
Date: | 2003-11-21 15:06:54 |
Message-ID: | 3FBE2A0E.3010308@myrealbox.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-11-21 15:10:26 | Re: logical column position |
Previous Message | Matthew T. O'Connor | 2003-11-21 14:56:17 | Re: [HACKERS] More detail on settings for pgavd? |
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew T. O'Connor | 2003-11-21 15:17:31 | Re: [HACKERS] More detail on settings for pgavd? |
Previous Message | Matthew T. O'Connor | 2003-11-21 14:56:17 | Re: [HACKERS] More detail on settings for pgavd? |