Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Request to confirm which command is use for exclusive operation - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] Request to confirm which command is use for exclusive operation
Date
Msg-id CAKFQuwbXW+EZkR-kFXre6x=SY92PBj+5_scM125vpfzQAupQxA@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Request to confirm which command is use for exclusive operation  (Yogesh Sharma <yogeshraj95@gmail.com>)
Responses Re: [GENERAL] Request to confirm which command is use for exclusive operation
List pgsql-general
Tree view
On Tuesday, March 7, 2017, Yogesh Sharma <yogeshraj95@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.


That a reindex blocks writes implies the reverse, any writes in progress will prevent the reindex from starting.

David J.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Unable to start postgresql
Next
From: Yogesh Sharma
Date:
Subject: Re: [GENERAL] Request to confirm which command is use for exclusive operation