Re: how to investigate GIN fast updates and cleanup cycles?

Поиск
Список
Период
Сортировка
От Steve Kehlet
Тема Re: how to investigate GIN fast updates and cleanup cycles?
Дата
Msg-id CA+bfosF=tpA0TKQDz19bSGMjSyMoUVaLn7FD5J3vNiYrGKLNHw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: how to investigate GIN fast updates and cleanup cycles?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
On Fri, Aug 28, 2015 at 11:18 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
It looks like a VACUUM will do the cleanup during the first ginbulkdelete
call, so you could probably handle this by running a manual "VACUUM
VERBOSE" with the smallest possible maintenance_work_mem, and canceling it
as soon as you see something reported about the GIN index.

Since I'm back to running VACUUM VERBOSE by hand, can you clarify for me how reducing maintenance_work_mem (currently 512MB) will speed it up? Will it work in smaller chunks? So just do something like:

set maintenance_work_mem = '32MB';
VACUUM VERBOSE my_table';

How do I determine the smallest value possible? Just start small (32MB?) and see if it fails, and increase until it doesn't?

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

Предыдущее
От: Steve Kehlet
Дата:
Сообщение: Re: how to investigate GIN fast updates and cleanup cycles?
Следующее
От: kingl
Дата:
Сообщение: wal files stay in the pg_xlog dir