| From: | Ruben Rubio <ruben(at)rentalia(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Vacuum full is slow |
| Date: | 2007-03-19 11:02:44 |
| Message-ID: | 45FE6DD4.7080304@rentalia.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
-----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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2007-03-19 11:23:15 | Re: Vacuum full is slow |
| Previous Message | Vincenzo Romano | 2007-03-19 10:18:55 | Re: function call vs staright query |