-----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-----