| From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
|---|---|
| To: | Jan Wieck <JanWieck(at)yahoo(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] Buglist |
| Date: | 2003-08-22 16:02:14 |
| Message-ID: | 1061568134.4943.3.camel@zeutrh9 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Fri, 2003-08-22 at 11:08, Jan Wieck wrote:
> > Another way to give autovacuum some hints would be to return some number
> > as commandtuples from vacuum. like the number of tuples actually
> > vacuumed. That together with the new number of reltuples in pg_class
> > will tell autovacuum how frequent a relation really needs scanning.
>
> Which actually would be much better because it'd work without the
> statistics collector configured for gathering IO stats.
Which is certainly a good thing. Using the stats system is a measurable
performance hit.
I still want to play with pg_autovacuum ignoring the stats system and
just looking at the FSM data.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-08-22 16:03:57 | Re: Buglist |
| Previous Message | Shridhar Daithankar | 2003-08-22 15:47:04 | Re: Buglist |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-08-22 16:03:57 | Re: Buglist |
| Previous Message | Stephan Szabo | 2003-08-22 15:47:30 | Re: [SQL] "SELECT IN" Still Broken in 7.4b |