On Wed, 2003-07-02 at 11:16, [EMAIL PROTECTED] wrote: > > REINDEX and VACUUM FULL are just as good. > > Isn't there a difference between them up to 7.4? I thought that there > were still cases where VACUUM FULL wouldn't pick up on regions of dead > keys where they would never get reused. (Typically because the index is > on a sequenced field where old pages never get referenced again...)
I lost the thread, but I believe that I meant that REINDEX + VACUUM FULL == database dump / reload. The results should be similar. -- Rod Taylor <[EMAIL PROTECTED]> PGP Key: http://www.rbt.ca/rbtpub.asc
signature.asc
Description: This is a digitally signed message part