Re: pg_avd

From: Olleg Samoylov <olleg(at)jane(dot)telecom(dot)mipt(dot)ru>
To: Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: pg_avd
Date: 2003-02-18 14:04:19
Message-ID: Pine.LNX.4.33.0302181644560.19296-100000@jane.telecom.mipt.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • Re: pg_avd at 2003-02-18 03:25:31 from Bruce Momjian

Responses

  • Re: pg_avd at 2003-02-18 18:07:34 from Matthew T. O'Connor

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2003-02-18 14:43:38 Re: Non-colliding auto generated names
Previous Message Christopher Kings-Lynne 2003-02-18 08:32:56 Re: pg_avd