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