Re: Row level stats

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: Row level stats
Дата
Msg-id 1046969020.487.23.camel@jester
обсуждение исходный текст
Ответ на Re: Row level stats  (Neil Conway <neilc@samurai.com>)
Ответы Re: Row level stats
Re: Row level stats
Список 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 по дате отправления:

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: Row level stats
Следующее
От: Neil Conway
Дата:
Сообщение: Re: Row level stats