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                        [EMAIL PROTECTED]
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

Attachment: pgpg1nfqTdVBY.pgp
Description: PGP signature

Reply via email to