Horton

Re: Some thoughts about i/o priorities and throttling vacuum

Alvaro Herrera <alvherre@dcc.uchile.cl>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@dcc.uchile.cl>
To: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
Cc: pgsql-hackers@postgresql.org
Date: 2003-10-17T14:06:05Z
Lists: pgsql-hackers 
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)