Re: [HACKERS] Buglist - Mailing list pgsql-general

From Matthew T. O'Connor
Subject Re: [HACKERS] Buglist
Date
Msg-id 1061568134.4943.3.camel@zeutrh9
Whole thread Raw
In response to Re: [HACKERS] Buglist  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Buglist
Next
From: "scott.marlowe"
Date:
Subject: Re: Buglist