Re: autovacuum, xid wraparound, pg_database column values

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: autovacuum, xid wraparound, pg_database column values
Дата
Msg-id 29728.1149690470@sss.pgh.pa.us
обсуждение исходный текст
Ответ на autovacuum, xid wraparound, pg_database column values  ("shakahshakah@gmail.com" <shakahshakah@gmail.com>)
Список pgsql-general
"shakahshakah@gmail.com" <shakahshakah@gmail.com> writes:
> I'm trying to make sense of Section 22.1.3 ("Preventing transaction ID
> wraparound failures") in the on-line docs to make sure the DB's
> autovacuum settings are adequate and are having an effect.
> ...
> I don't see numbers larger than 1 billion in my pg_database columns,
> though.

The pg_database columns only update when you do a database-wide VACUUM,
which is something that autovacuum only undertakes when it sees that
the age values are getting large.  I forget the exact threshold, but
at ~28M transactions you are certainly a long way away.

            regards, tom lane

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

Предыдущее
От: "Magnus Hagander"
Дата:
Сообщение: Re: Can PostGreSQL slow down a Windows PC much?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Problem with 'postgres' db with 8.0 on a MacBook