Re: Request to confirm which command is use for exclusive operation

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Yogesh Sharma <yogeshraj95(at)gmail(dot)com>
Cc: pgsql-general general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Request to confirm which command is use for exclusive operation
Date: 2017-03-08 06:03:12
Message-ID: CAKFQuwbXW+EZkR-kFXre6x=SY92PBj+5_scM125vpfzQAupQxA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yogesh Sharma 2017-03-08 06:21:29 Re: Request to confirm which command is use for exclusive operation
Previous Message Adrian Klaver 2017-03-08 05:09:56 Re: Unable to start postgresql