Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C355A9FB398 for ; Mon, 19 Mar 2007 08:09:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 25672-03 for ; Mon, 19 Mar 2007 08:09:39 -0300 (ADT) X-Greylist: delayed 00:06:39.070405 by SQLgrey-1.7.4 Received: from mail.rentalia.com (mail.rentalia.com [213.192.209.8]) by postgresql.org (Postfix) with ESMTP id F3D549FB294 for ; Mon, 19 Mar 2007 08:09:38 -0300 (ADT) Received: (qmail 3751 invoked by uid 509); 19 Mar 2007 12:02:57 +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 1.98513 secs); 19 Mar 2007 11:02:57 -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 1.98513 secs Process 3620) 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 12:02:55 +0100 Message-ID: <45FE6DD4.7080304@rentalia.com> Date: Mon, 19 Mar 2007 12:02:44 +0100 From: Ruben Rubio User-Agent: Thunderbird 1.5.0.10 (X11/20070306) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Vacuum full is slow 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/274 X-Sequence-Number: 23679 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, Vacuum full is very slow for me . I dont know how to speed it up. It takes between 60 and 90 minutes. I have set up autovacuum but I also run vacuum full once per week. The slowest parts in the vacuum full output are : INFO: "a": moved 14076 row versions, truncated 6013 to 1005 pages DETAIL: CPU 3.51s/2.16u sec elapsed 1156.00 sec. INFO: "b": moved 22174 row versions, truncated 1285 to 933 pages DETAIL: CPU 3.77s/1.52u sec elapsed 443.79 sec. INFO: "c": moved 36897 row versions, truncated 2824 to 1988 pages DETAIL: CPU 3.26s/1.45u sec elapsed 676.18 sec. How can I speed it up? Postgres version 8.1.3 Thanks in advance -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFF/m3UIo1XmbAXRboRAnfHAKCVobTZGF9MlTjuAOkzIQESv1SDoQCfah67 hdCkn/4KtnlYk1mqcS1u8bY= =/3Y4 -----END PGP SIGNATURE-----