Re: pg_autovacuum and VACUUM FREEZE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_autovacuum and VACUUM FREEZE
Дата
Msg-id 18950.1066313622@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_autovacuum and VACUUM FREEZE  ("Matthew T. O'Connor" <matthew@zeut.net>)
Список pgsql-hackers
"Matthew T. O'Connor" <matthew@zeut.net> writes:
> The vacuum man page says, "FREEZE is not recommnded for routine use". 
> That was enough to keep me away.  However if vacuum freeze was
> considerably lighter than normal database wide vacuums then there might
> be an advantage to using it.

If anything it would be slower than normal vacuum (more pages touched).
I concur with just using plain VACUUM to deal with impending wraparound.
        regards, tom lane


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

Предыдущее
От: "Matthew T. O'Connor"
Дата:
Сообщение: Re: pg_autovacuum and VACUUM FREEZE
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Still a few flaws in configure's default CFLAGS