Re: Autovacuum of pg_database

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Autovacuum of pg_database
Дата
Msg-id 20160510201528.GA664314@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: Autovacuum of pg_database  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Tom Lane wrote:

> I'll bet they're all trying to do anti-wraparound vacuums.  This would
> explain why the problem hasn't been observed often enough to have been
> fixed long since.

Ah, that should have been obvious, shouldn't it.  I'm able to reproduce
the problem by moving relfrozenxid backwards for a shared catalog, and I
can confirm that it works correctly with the patch proposed, so I have
pushed it to all branches.  (I only tested the problem scenario in 9.1
and master, since it's too much manual work).

Thanks for the report!

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: Mike Broers
Дата:
Сообщение: Re: driving postgres to achieve benchmark results similar to bonnie++
Следующее
От: "Campbell, Lance"
Дата:
Сообщение: Memory and Swap