Re: "Create index" lock type

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: "Create index" lock type
Дата
Msg-id CAKFQuwandQ-4pjUwKds+kk87x7LH3EfeyNncpvjG3xb0_0kvLg@mail.gmail.com
обсуждение исходный текст
Ответ на "Create index" lock type  ("Greg Rychlewski (LCL)" <Greg.Rychlewski@loblaw.ca>)
Список pgsql-novice
On Tuesday, July 14, 2020, Greg Rychlewski (LCL) <Greg.Rychlewski@loblaw.ca> wrote:

What kind of lock does the  “create index” (not concurrent) command take? From the documentation, it says that it blocks out writes. But I’m not sure how to find the exact lock type in the documentation.

 

The reason I’m asking is because I’m trying to see if it conflicts with the lock taken by autovacuum (to prevent wraparound), “SHARE UPDATE EXCLUSIVE”.

Share


David J.

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Greg Rychlewski (LCL)"
Дата:
Сообщение: "Create index" lock type
Следующее
От: Devraj B
Дата:
Сообщение: How to connect PostgreSQL (9.6.17) database from Macbook Pro Terminal using JumpCloud password?