-----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----- ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
