Re: Row level stats - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: Row level stats
Date
Msg-id 1046969020.487.23.camel@jester
Whole thread Raw
In response to Re: Row level stats  (Neil Conway <neilc@samurai.com>)
Responses Re: Row level stats  (Neil Conway <neilc@samurai.com>)
Re: Row level stats  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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

pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: Row level stats
Next
From: Neil Conway
Date:
Subject: Re: Row level stats