Re: Some thoughts about i/o priorities and throttling vacuum - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Some thoughts about i/o priorities and throttling vacuum
Date
Msg-id 20031017140605.GA3723@dcc.uchile.cl
Whole thread Raw
In response to Re: Some thoughts about i/o priorities and throttling vacuum  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Responses Re: Some thoughts about i/o priorities and throttling vacuum
List 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)


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Mapping Oracle types to PostgreSQL types
Next
From: Shridhar Daithankar
Date:
Subject: Re: Some thoughts about i/o priorities and throttling vacuum