Tom Lane <tgl@sss.pgh.pa.us> 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