Re: Row level stats

On Thu, 2003-03-06 at 11:40, Neil Conway wrote:
> On Thu, 2003-03-06 at 09:16, Rod Taylor wrote:
> > Anyway, the basic proposal would be to change the on / off flags for row
> > & block level into a 'stats delay'.  A large number would be off, 0
> > would have the same properties as today.  Default to be determined (but
> > 1 second seems to be plenty).
>
> "A large number" seems messy. Why not "-1"? I also don't really like
> using "0" to mean "enabled", but I can't think of anything better...
>
> And the default should be to disable row-level stats, naturally.

Not if we expect pg_autovacuum to be able to work. It *needs* this
information.  I really want an auto-vacuum in the backend, and figured
the first step was to fix stats so they don't have such a high cost.

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc