Re: Long-running and non-finishing VACUUM ANALYZE on large table

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Long-running and non-finishing VACUUM ANALYZE on large table
Дата
Msg-id 4139.1443816949@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Long-running and non-finishing VACUUM ANALYZE on large table  (Jan <pgsql.admin@j.mk-contact.de>)
Ответы Re: Long-running and non-finishing VACUUM ANALYZE on large table
Список pgsql-admin
Дерево обсуждения 
Ben Primrose <bprimrose@tracelink.com> writes:
> Tom, how'd you determine the maintenance_work_mem?

From the numbers of tuples shown as being removed in each index pass.
The work-mem usage is 6 bytes per TID, and it'll stop and do an index
pass once we get close to full.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Long-running and non-finishing VACUUM ANALYZE on large table
Следующее
От: Ben Primrose
Дата:
Сообщение: Re: Long-running and non-finishing VACUUM ANALYZE on large table