Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 9626D9FB63C for ; Mon, 19 Mar 2007 11:21:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 15001-02 for ; Mon, 19 Mar 2007 11:21:03 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.rentalia.com (mail.rentalia.com [213.192.209.8]) by postgresql.org (Postfix) with ESMTP id 4A8E29FB933 for ; Mon, 19 Mar 2007 11:21:09 -0300 (ADT) Received: (qmail 2635 invoked by uid 509); 19 Mar 2007 15:21:06 +0100 Received: from 88.0.11.2 by nemo (envelope-from , uid 507) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.7/2476. spamassassin: 3.0.6. perlscan: 1.25-st-qms. Clear:RC:0(88.0.11.2):SA:0(-2.3/5.0):. Processed in 0.766922 secs); 19 Mar 2007 14:21:06 -0000 X-Antivirus-MYDOMAIN-Mail-From: ruben@rentalia.com via nemo X-Antivirus-MYDOMAIN: 1.25-st-qms (Clear:RC:0(88.0.11.2):SA:0(-2.3/5.0):. Processed in 0.766922 secs Process 2613) Received: from 2.red-88-0-11.dynamicip.rima-tde.net (HELO ?192.168.2.28?) (ruben@rentalia.com@88.0.11.2) by mail.rentalia.com with SMTP; 19 Mar 2007 15:21:05 +0100 Message-ID: <45FE9C4B.7070602@rentalia.com> Date: Mon, 19 Mar 2007 15:20:59 +0100 From: Ruben Rubio User-Agent: Thunderbird 1.5.0.10 (X11/20070306) MIME-Version: 1.0 To: Heikki Linnakangas CC: pgsql-performance@postgresql.org Subject: Re: Vacuum full is slow References: <45FE6DD4.7080304@rentalia.com> <45FE72A3.5020709@enterprisedb.com> In-Reply-To: <45FE72A3.5020709@enterprisedb.com> X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/277 X-Sequence-Number: 23682 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > > You don't have vacuum_cost_delay set, do you? How long does normal > vacuum run? vacuum_cost_delay = 100 No idea how long will take normal vacuum. I ll try tonight when there is not too much load. > > The manual suggests dropping all indexes before running vacuum full, and > recreating them afterwards. That's worth trying. > I ll try that also. Is there any way to do it? Do i have to delete / create each one manually? -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFF/pxLIo1XmbAXRboRAjR1AJ9V4kBDCd++HSmUm8+ZCLs2RY0xnACfZ7Mp uBC031TFhO2NGOihfWPAQQ8= =QCYi -----END PGP SIGNATURE-----