Feature: vacuum page before write

Поиск
Список
Период
Сортировка
От pasman pasmański
Тема Feature: vacuum page before write
Дата
Msg-id AANLkTimeJQ609A2ZxS+umEPSfqaBGin-hJkHwJ_B1pXr@mail.gmail.com
обсуждение исходный текст
Ответы Re: Feature: vacuum page before write  (Radosław Smogura <rsmogura@softperience.eu>)
Список pgsql-general
Hi.
I propose new feature.
Before flushing page of table to disk it may be scanned to reclaim
deleted rows. And assigned as partially vacuumed or vacuumed.
It may reduce bloat in frequently updated tables and make normal
(auto)vacuum faster.
Additional scan adds overhead to cpu (for update/delete), but seq scan
will be faster and disk io usage will be lower.
I don't know what is happen when a index entry points to reclaimed row.


--
------------
pasman

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

Предыдущее
От: Bill Thoen
Дата:
Сообщение: Directing Partitioned Table Searches
Следующее
От: gargdevender74
Дата:
Сообщение: unable to publish layer