Horton

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

Andrew Sullivan <andrew@libertyrms.info>

View thread View on postgr.es
From: Andrew Sullivan <andrew@libertyrms.info>
To: pgsql-hackers@postgresql.org
Date: 2003-10-17T13:50:07Z
Lists: pgsql-hackers 
On Fri, Oct 17, 2003 at 07:04:45PM +0530, Shridhar Daithankar wrote:
> I am slightly confused here. IIRC pg_autovacuum never did a vacuum full. At 
> the most it does vacuum /vacuum analyse, none of which chew disk bandwidth. 

The latter is false.  VACUUM FULL certainly uses _more_ disk
bandwidth than VACUUM, but it's just false that plain VACUUM doesn't
contend for disk.  And if you're already maxed, then that extra
bandwidth you cannot afford.

A


-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Afilias Canada                        Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110