Tom Lane <[EMAIL PROTECTED]> wrote: > > Can we do REINDEX > > holding only shared lock on the index? > > No. When you commit the reindex, the old copy of the index will > instantaneously disappear; it will not do for someone to be actively > scanning that copy.
Hmm... Is it ok if the index will *not* instantaneously disappear? Keeping the old copy for a while and removing it after all transactions are finished. It would be "pending truncate entries", that is something like pending unlink entries in 8.3. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq