Re: Row level stats

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: Row level stats
Дата
Msg-id 1046969736.487.27.camel@jester
обсуждение исходный текст
Ответ на Re: Row level stats  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Row level stats
Список pgsql-hackers
On Thu, 2003-03-06 at 11:49, Tom Lane wrote:
> Rod Taylor <rbt@rbt.ca> writes:
> > Not if we expect pg_autovacuum to be able to work. It *needs* this
> > information.
>
> Why?
>
> The implementation I've had in mind for autovacuum would rely on FSM not
> the pg_stats daemon.

FSM as I understand it gets it information from vacuum, and has an space
marker removed when an insert uses the tuple.

Determining when vacuum runs would be based more on Deletes / updates
than anything wouldn't it?


Anyhow, I'd be curious to know your full thoughts on autovacuum and how
it may work.

--
Rod Taylor <rbt@rbt.ca>

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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Partial index on date column
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Row level stats