Jennifer Spencer <jenniferm411@xxxxxxxxxxx> wrote: > Hm - Kevin, when you issue CLUSTER on your table, when do you switch > the users over and do you let them keep writing during the process? > Or is the second copy table read-only to the users while the > cluster-build is happening on the primary (making it unavailable)? > Thanks - and thanks for the Sybase difference explanation. We only use CLUSTER occassionally, to recover from bloat caused by exceptional circumstances (like mass deletes or a long-running transaction from some will-behaved programmer.). CLUSTER has to lock the table for the duration, blocking other users. We schedule this off-hours. I'm glad the info was useful. Our move from Sybase was incredibly smooth, due largely to help from these PostgreSQL lists; I figure I owe it to the community to give back as I am able. :-) -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
