Re: pg_avd - Mailing list pgsql-patches

From Olleg Samoylov
Subject Re: pg_avd
Date
Msg-id Pine.LNX.4.33.0302181644560.19296-100000@jane.telecom.mipt.ru
Whole thread Raw
In response to Re: pg_avd  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: pg_avd
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Non-colliding auto generated names
Next
From: Bruce Momjian
Date:
Subject: Re: FAQ addition: deleteing all but one unique row