Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 57E119F9242 for ; Tue, 23 Oct 2007 13:36:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 88707-09 for ; Tue, 23 Oct 2007 13:36:43 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from pd4mo2so.prod.shaw.ca (idcmail-mo1so.shaw.ca [24.71.223.10]) by postgresql.org (Postfix) with ESMTP id 308059F9939 for ; Tue, 23 Oct 2007 13:36:43 -0300 (ADT) Received: from pd3mr4so.prod.shaw.ca (pd3mr4so-qfe3.prod.shaw.ca [10.0.141.180]) by l-daemon (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <0JQD0049HI3A8QD0@l-daemon> for pgsql-performance@postgresql.org; Tue, 23 Oct 2007 10:35:34 -0600 (MDT) Received: from pn2ml8so.prod.shaw.ca ([10.0.121.152]) by pd3mr4so.prod.shaw.ca (Sun Java System Messaging Server 6.2-7.05 (built Sep 5 2006)) with ESMTP id <0JQD0064UI3A9P30@pd3mr4so.prod.shaw.ca> for pgsql-performance@postgresql.org; Tue, 23 Oct 2007 10:35:34 -0600 (MDT) Received: from [192.168.0.102] ([24.68.192.206]) by l-daemon (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <0JQD001YQI39WAM0@l-daemon> for pgsql-performance@postgresql.org; Tue, 23 Oct 2007 10:35:34 -0600 (MDT) Date: Tue, 23 Oct 2007 09:33:16 -0700 From: Ron St-Pierre Subject: Re: 12 hour table vacuums In-reply-to: <20071023120750.ad8a1f54.wmoran@collaborativefusion.com> To: Bill Moran Cc: pgsql-performance@postgresql.org Message-id: <471E224C.5060607@shaw.ca> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7bit References: <471E18ED.3090704@shaw.ca> <20071023120750.ad8a1f54.wmoran@collaborativefusion.com> User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/256 X-Sequence-Number: 27278 Bill Moran wrote: > In response to Ron St-Pierre : > > >> We vacuum only a few of our tables nightly, this one is the last one >> because it takes longer to run. I'll probably re-index it soon, but I >> would appreciate any advice on how to speed up the vacuum process (and >> the db in general). >> > > I doubt anyone can provide meaningful advice without the output of > vacuum verbose. > > The cron job is still running /usr/local/pgsql/bin/vacuumdb -d imperial -t stock.fdata -v -z > /usr/local/pgsql/bin/fdata.txt I'll post the output when it's finished. Ron