Joshua D. Drake wrote:
-----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.
Thank you Joshua.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
