Re: Autovacuum to-do list

On Thu, Jul 28, 2005 at 11:42:22AM +1000, Gavin Sherry wrote:
> On Wed, 27 Jul 2005, Alvaro Herrera wrote:
>
> * Change how we track the need to vacuum
>
> I don't really think the use of row level stats are the best
> indicator for a need to vacuum. I wonder if we could keep a
> counter for each segment (ie, every 1 GB file backing a heap or
> index) or file which indicates the number of blocks which have been
> dirtied since the last vacuum. The user would specify a threshold
> of X blocks and once we reached that we would invoke vacuum.

Interesting approach. I don't think it's too difficult to implement.
We just need a new stat message indicating that block N was dirtied
because of new or deleted tuples (hint bit changes need not apply)

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"I love the Postgres community. It's all about doing things _properly_. :-)"
(David Garamond)