Re: pg_avd

Поиск
Список
Период
Сортировка
От Olleg Samoylov
Тема Re: pg_avd
Дата
Msg-id Pine.LNX.4.33.0302181644560.19296-100000@jane.telecom.mipt.ru
обсуждение исходный текст
Ответ на Re: pg_avd  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: pg_avd  ("Matthew T. O'Connor" <matthew@zeut.net>)
Список pgsql-patches
Hi all,

On one hand pg_autovacuum must give opportunity to launch it without sleep
loop, for instance for launch it at night by cron, then it vacuumed only
tables which needed it.

On other, if pg_autovacuum running as daemon, IMHO better launch it from
postmaster, in the same manner, as launched statistic collector.

Must pg_autovacuum also check transaction ID (XID) numbers to prevent
transaction ID wraparound? (PostgreSQL v.7.3.1 docs 8.2.3. Preventing
transaction ID wraparound failures)

And must it reindex in the same manner as contrib/reindexdb? (PostgreSQL
v.7.3.1 docs 8.3. Routine Reindexing)

--
Olleg Samoylov



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Non-colliding auto generated names
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: FAQ addition: deleteing all but one unique row