Re: [HACKERS] Autovacuum Improvements

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: [HACKERS] Autovacuum Improvements
Дата
Msg-id 20070121134410.GB2123@svana.org
обсуждение исходный текст
Ответ на Re: [HACKERS] Autovacuum Improvements  ("Simon Riggs" <simon@2ndquadrant.com>)
Список pgsql-general
On Sun, Jan 21, 2007 at 12:24:38PM +0000, Simon Riggs wrote:
> Partial vacuum would still be possible if you remembered where you got
> to in the VACUUM and then started from that same point next time. It
> could then go to the end of the table and wrap back around.

ISTM the Dead Space Map would give you this automatically, since that's
your memory... Once you have the DSM to track where the dead pages are,
you can set it up to target clusters first, thus giving maximum bang
for buck.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Вложения

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

Предыдущее
От: "Mike Poe"
Дата:
Сообщение: Replicating Binary Data from MS SQL 2000 to PG 8.2
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Using transactions with plpythonu