On Tuesday, March 7, 2017, Yogesh Sharma <yogeshra...@gmail.com> wrote:
> Dear all, > > Thanks for your support. > > I need to perfrom INSERT and REINDEX operation exclusively. > For example: > If REINDEX operation is in progress then INSERT operation will wait and > vice versa. > > Please let me know if any approach is available. > > The docs describe REINDEX locking mechanics. https://www.postgresql.org/docs/current/static/sql-reindex.html That a reindex blocks writes implies the reverse, any writes in progress will prevent the reindex from starting. David J.
