Skipping VACUUM of indexes when no work required

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Skipping VACUUM of indexes when no work required
Дата
Msg-id 1133956836.2906.891.camel@localhost.localdomain
обсуждение исходный текст
Ответы Re: Skipping VACUUM of indexes when no work required  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Skipping VACUUM of indexes when no work required  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
Дерево обсуждения 
We discussed an optimization of VACUUM here
http://archives.postgresql.org/pgsql-hackers/2005-09/msg00046.php
that would allow VACUUM to complete faster by avoiding scanning the
indexes when no rows were removed from the heap by the VACUUM.

Patch applies cleanly on cvstip; make check passes.

Tests shows clear performance gain when no rows removed by VACUUM.

Not as useful as may once have been, but certainly no loss either,
whatever happens in the future with VACUUM.

Best Regards, Simon Riggs
Вложения

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

Предыдущее
От: "Los Mejores Cursos Gubernamentales"
Дата:
Сообщение: Capacitacion para Servidores Publicos ciclo Dic-Enero //*0512759742388adr
Следующее
От: Simon Riggs
Дата:
Сообщение: Minor spelling correction on cvstip