| 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? |