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-17T15:19:05Z
Lists: pgsql-hackers 
On Fri, Oct 17, 2003 at 07:25:13PM +0530, Shridhar Daithankar wrote:
> What part of plain vacuum takes disk bandwidth? WAL? Clog? Certainly not 
> data files themselves, right?

Sure, the data files.  The data files still have to be completely
read from beginning to end by VACUUM.

A

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