Re: Template0 datfrozenxid age is 160million and progressing

Поиск
Список
Период
Сортировка
От Stephen Eilert
Тема Re: Template0 datfrozenxid age is 160million and progressing
Дата
Msg-id 1533154117.3567315.1460357192.6B184715@webmail.messagingengine.com
обсуждение исходный текст
Ответ на Re: Template0 datfrozenxid age is 160million and progressing  (Rijo Roy <rjo_roy@yahoo.com>)
Список pgsql-general
160 million is a very low number. I manage production databases which reach this value in a day easily. As other said, 200 million is the default threshold for the anti-wraparound vacuums. I wouldn't worry, specially for template0.

That said, there is nothing preventing you from temporarily changing DATALLOWCONN, running vaccuum (which should be very quick) and then changing it back. But you should not have to.  I do that in our production database, but only because it suffers from a bad schema design and we ended up with thousands of tables, which is too much for the autovacuum workers to cope alone, so they need a manual "boost". I still don't disable autovacuum.

I don't really understand the bit about autovacuum changing query performance. In which scenario would it be preferable to have outdated analyzer statistics? This would be like running a system with garbage collection disabled because GC can increase the amount of free memory. That's the whole point.

— Stephen

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Adding terminal title support for psqlrc
Следующее
От: Richard Schmidt
Дата:
Сообщение: Pg_rewind cannot load history wal