Re: partial VACUUM FULL

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: partial VACUUM FULL
Дата
Msg-id 40610EAD.60307@joeconway.com
обсуждение исходный текст
Ответ на Re: partial VACUUM FULL  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: partial VACUUM FULL  (Joseph Shraibman <jks@selectacast.net>)
Список pgsql-general
Tom Lane wrote:
> This is completely untrue.  Increasing vacuum_mem will likely make
> things faster on large tables (by avoiding the need for multiple passes
> over the indexes).  It will not change the end result though.

I can attest to that, based on very recent empirical evidence. On a 28
million row table, I saw something like 33% speed-up in going from 256MB
to 320MB for vacuum_mem.

Joe


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

Предыдущее
От: glenn
Дата:
Сообщение: ole db
Следующее
От: Joseph Shraibman
Дата:
Сообщение: Re: partial VACUUM FULL