Postgres Pro
Downloads
Home   >   mailing lists

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

From Yogesh Sharma
Subject Re: [GENERAL] Request to confirm which command is use for exclusive operation
Date
Msg-id CAEZUwCS-F00Amyf7uScw7e35A2cop=J4fTyU9spXjQ3aHxyMjw@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Request to confirm which command is use for exclusive operation  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: [GENERAL] Request to confirm which command is use for exclusive operation  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: [GENERAL] Request to confirm which command is use for exclusiveoperation  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Re: [GENERAL] Request to confirm which command is use for exclusive operation  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
Dear David,

 I want to apply explicitly lock mechanism once inset operation is in progress then REINDEX will wait.
And vice versa.
So, please let me know this type of handling is possible.
Regrds,
Yogesh

On Wednesday, March 8, 2017, David G. Johnston <david.g.johnston@gmail.com> wrote:
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: "David G. Johnston"
Date:
Subject: Re: [GENERAL] Request to confirm which command is use for exclusive operation
Next
From: Scott Marlowe
Date:
Subject: Re: [GENERAL] Request to confirm which command is use for exclusive operation