-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Mon, 07 Jan 2008 10:53:11 -0500 Geoffrey <lists@xxxxxxxxxxxxxxxxxxxxx> wrote: > So, I'm wondering if anyone can point me to more specific information > as to when, if ever, you should 'vacuum full?' 1. If you over run your fsm pages * Except that vacuum full won't reclaim the index usage so use CLUSTER instead. 2. If you are only repairing bloat on a smaller table. * It may be faster to backup and restore the table. Since vacuum full is an exclusive lock anyway it doesn't matter. Sincerely, Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD' -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHgl1rATb/zqfZUUQRAod6AKCUkRKy+gqOkb4xpgVXiP8BCIePKQCgo2yS ZRmnIVwrYHFoJ8juI08KL6c= =Jb1i -----END PGP SIGNATURE----- ---------------------------(end of broadcast)---------------------------TIP 2: Don't 'kill -9' the postmaster
