Re: Specific questions about wraparound and vacuum

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Specific questions about wraparound and vacuum
Дата
Msg-id 12068.1186625785@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Specific questions about wraparound and vacuum  ("Nick Fankhauser" <nickf@doxpop.com>)
Список pgsql-admin
"Nick Fankhauser" <nickf@doxpop.com> writes:
> On 8/8/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Do your vacuums change the pg_database.datfrozenxid values for the
>> databases?  The only reason I can think of for them not to do so
>> is if you're not doing them as superuser ...

> They do change the values- I noted this by selecting age(datfrozenxid)
> in template1 both before and after vacuuming and noting the change.

Uh, that proves very little, because age() is a moving target.  Did the
raw datfrozenxid column values change?

> Our regular vacuum process only runs on our single "prod" database-
> not template1. Is template1 a "frozen" database, or just template0?

template1 is not frozen in a standard installation.  Basically you gotta
vacuum everything that has datallowconn = true.

            regards, tom lane

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

Предыдущее
От: Jessica Richard
Дата:
Сообщение: Does Postgres 8.x support stored procedure?
Следующее
От: Jessica Richard
Дата:
Сообщение: cpu usage on the linux machine