Re: Vacuum thoughts

Поиск
Список
Период
Сортировка
От Shridhar Daithankar
Тема Re: Vacuum thoughts
Дата
Msg-id 3F936DC1.9070307@persistent.co.in
обсуждение исходный текст
Ответ на Re: Vacuum thoughts  (Gaetano Mendola <mendola@bigfoot.com>)
Ответы Re: Vacuum thoughts  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Gaetano Mendola wrote:
> The vacuum cost is the same of a full scan table ( select count(*) ) ?
> Why not do a sort of "vacuum" if a scan table happen ( during a simple
> select that invole a full scan table for example )?

I was thinking about it. How about vacuuming a page when it is been pushed out 
of postgresql buffer cache? It is is memory so not much IO is involved.

Could it be an approach?
 Shridhar



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

Предыдущее
От: Christopher Browne
Дата:
Сообщение: Re: Dreaming About Redesigning SQL
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Dreaming About Redesigning SQL