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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [GENERAL] Request to confirm which command is use for exclusive operation
Дата
Msg-id CAKFQuwbXW+EZkR-kFXre6x=SY92PBj+5_scM125vpfzQAupQxA@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Request to confirm which command is use for exclusive operation  (Yogesh Sharma <yogeshraj95@gmail.com>)
Ответы Re: [GENERAL] Request to confirm which command is use for exclusive operation  (Yogesh Sharma <yogeshraj95@gmail.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] Unable to start postgresql
Следующее
От: Yogesh Sharma
Дата:
Сообщение: Re: [GENERAL] Request to confirm which command is use for exclusive operation