On Fri, Oct 17, 2003 at 07:04:45PM +0530, Shridhar Daithankar wrote: > And if pg_autovacuum is running along with postmaster all the time, with > aggressive polling like 5 sec, the database should not accumulate any dead > tuples nor it would suffer xid wraparound as there are vacuum happening > constantly.
The database can suffer XID wraparound anyway if there's at least one table without updates, because the autovacuum daemon will never vacuum it (correct me if I'm wrong). -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) "Tiene valor aquel que admite que es un cobarde" (Fernandel) ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
