On Tue, Aug 07, 2007 at 08:40:47AM -0700, Steve Atkins wrote: > If you have adequate disk space free (enough to hold another > copy of the new table) and the table has an index on it, then > CLUSTER the table. Be advised that there's some MVCC issues with CLUSTER in current versions, but normally you'd only run into them in a serialized transaction. If you're not using that you're probably fine, but remember that pg_dump and pg_dumpall use serialized transactions. -- Decibel!, aka Jim Nasby decibel@xxxxxxxxxxx EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
Attachment:
pgpNaKAKCyrUH.pgp
Description: PGP signature
