Re: autovacuum next steps, take 2

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: autovacuum next steps, take 2
Дата
Msg-id 12462.1172554662@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: autovacuum next steps, take 2  ("Jim C. Nasby" <jim@nasby.net>)
Ответы Re: autovacuum next steps, take 2
Re: autovacuum next steps, take 2
Список pgsql-hackers
"Jim C. Nasby" <jim@nasby.net> writes:
> The proposal to save enough state to be able to resume a vacuum at
> pretty much any point in it's cycle might work; we'd have to benchmark
> it.  With the default maintenance_work_mem of 128M it would mean writing
> out 64M of state every minute on average, which is likely to take
> several seconds to fsync (though, maybe we wouldn't need to fsync it...)

Which is exactly why we needn't bother benchmarking it.  Even if it
weren't complex and unsafe, it will be a net loss when you consider the
fact that it adds I/O instead of removing it.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Expanding DELETE/UPDATE returning
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: COMMIT NOWAIT Performance Option