Re: Vacuum full is slow - Mailing list pgsql-performance

From Ruben Rubio
Subject Re: Vacuum full is slow
Date
Msg-id 45FE9C4B.7070602@rentalia.com
Whole thread Raw
In response to Re: Vacuum full is slow  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: Vacuum full is slow
List 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-----

pgsql-performance by date:

Previous
From: Vincenzo Romano
Date:
Subject: Re: text equality worse than pattern matching (v8.1.8)
Next
From: "Shoaib Mir"
Date:
Subject: Re: Vacuum full is slow