On Tuesday, March 7, 2017, Yogesh Sharma <yogeshraj95(at)gmail(dot)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.