| From: | Ruben Rubio <ruben(at)rentalia(dot)com> |
|---|---|
| To: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Vacuum full is slow |
| Date: | 2007-03-19 14:20:59 |
| Message-ID: | 45FE9C4B.7070602@rentalia.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
>
> You don't have vacuum_cost_delay set, do you? How long does normal
> vacuum run?
vacuum_cost_delay = 100
No idea how long will take normal vacuum. I ll try tonight when there is
not too much load.
>
> The manual suggests dropping all indexes before running vacuum full, and
> recreating them afterwards. That's worth trying.
>
I ll try that also. Is there any way to do it? Do i have to delete /
create each one manually?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFF/pxLIo1XmbAXRboRAjR1AJ9V4kBDCd++HSmUm8+ZCLs2RY0xnACfZ7Mp
uBC031TFhO2NGOihfWPAQQ8=
=QCYi
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shoaib Mir | 2007-03-19 14:37:41 | Re: Vacuum full is slow |
| Previous Message | Vincenzo Romano | 2007-03-19 12:02:57 | Re: text equality worse than pattern matching (v8.1.8) |