Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Vacuum full is slow
- 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: Mon, 19 Mar 2007 15:20:59 +0100
-----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-----
- Follow-Ups:
- Re: Vacuum full is slow
- From: Shoaib Mir
- Re: Vacuum full is slow
- References:
- Vacuum full is slow
- From: Ruben Rubio
- Re: Vacuum full is slow
- From: Heikki Linnakangas
- Vacuum full is slow
- Prev by Date: Re: text equality worse than pattern matching (v8.1.8)
- Next by Date: Re: Vacuum full is slow
- Previous by thread: Re: Vacuum full is slow
- Next by thread: Re: Vacuum full is slow
- Indexes: