Re: Free space mapping (was Re: Multi-Versions and Vacuum)

Поиск
Список
Период
Сортировка
От grant
Тема Re: Free space mapping (was Re: Multi-Versions and Vacuum)
Дата
Msg-id Pine.LNX.4.33.0207191311510.29118-100000@dbms.amadensor.com
обсуждение исходный текст
Ответ на Free space mapping (was Re: Multi-Versions and Vacuum)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения 
So, then, even if there is an overflow of pages with free space, stepping
up the vacuum schedule may help this eventually catch up.

As for an automated way to set this up, if the FSM size cannot be adjusted
without a restart of the postmaster, then on startup, you could take a
number of pages currently with free space or a percentage of the number of
pages, which ever is greater.  The percentage could have a default, and
also be configurable.

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

Предыдущее
От: Anthony Berglas
Дата:
Сообщение: Re: Multi-Versions and Vacuum -- cf Oracle & Vacuum alt
Следующее
От: Mike Mascari
Дата:
Сообщение: Re: Multi-Versions and Vacuum -- cf Oracle & Vacuum alt