Re: Skipping VACUUM of indexes when no work required

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Skipping VACUUM of indexes when no work required
Дата
Msg-id 29001.1133967320@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Skipping VACUUM of indexes when no work required  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: Skipping VACUUM of indexes when no work required  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Skipping VACUUM of indexes when no work required  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-patches
Simon Riggs <simon@2ndquadrant.com> writes:
> 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.

Unfortunately I can't read that message right now because archives
isn't responding, but this seems like a pretty bad idea to me.
You still have to do the vacuum cleanup pass (at least in the btree
case, and the only reason gist doesn't need it is it's not yet up
to speed) so there's no real savings.

            regards, tom lane

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Another example moved to SQL
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Minor spelling correction on cvstip