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
<[EMAIL PROTECTED]> M2P 2A8
+1 416 646 3304 x110
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
