Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrew Sullivan
Subject Re: Some thoughts about i/o priorities and throttling vacuum
Date
Msg-id 20031017135007.GA1089@libertyrms.info
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
Tree view 
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

pgsql-hackers by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: Mapping Oracle types to PostgreSQL types
Next
From: Tom Lane
Date:
Subject: Re: Some more information_schema issues