Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tuesday, March 7, 2017, Yogesh Sharma <yogeshraj95@xxxxxxxxx> 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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux