Re: Vacuum daemon (pgvacuumd ?)

> Is the number of deleted tuples sufficient to decide priority on vacuum? My
> thinking is that the tables with the most deleted tuples is the table which
> need most vacuum. Should ratio of deleted tuples vs total tuples or just count
> of deleted tuples. I am thinking ratio, but maybe it need be tunable.

Deleted or updated.  Both expire tuples.  Also, the old tuples can't be
vacuumed until no other transaction is viewing them as active.

> (4) If the tables eligible to be vacuumed have deleted tuples which exceed
> acceptable limits, vacuum them.

Seems you will measure in percentages, right?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026