From: Ruben Rubio <ruben@rentalia.com>
To: pgsql-performance@postgresql.org
Subject: Vacuum full is slow
Date: Mon, 19 Mar 2007 12:02:44 +0100
Message-ID: <45FE6DD4.7080304@rentalia.com> (raw)
-----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-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ruben@rentalia.com
Subject: Re: Vacuum full is slow
In-Reply-To: <45FE6DD4.7080304@rentalia.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox