[ADMIN] blocking issue when create index concurrently

Поиск
Список
Период
Сортировка
От xu jian
Тема [ADMIN] blocking issue when create index concurrently
Дата
Msg-id MWHPR20MB1421AEC7CEC67B159AC188F6A19A0@MWHPR20MB1421.namprd20.prod.outlook.com
обсуждение исходный текст
Ответы Re: [ADMIN] blocking issue when create index concurrently
Список pgsql-admin
Дерево обсуждения

Hello, 

          I was trying to create 2 indexes concurrently(on different table) in same database. I didn't expect the first create index operation would block the other one since they were running on different table.

However, it is not true. I found one creating index command was blocking the other one.

so I run the lock dependency query which I find from https://wiki.postgresql.org/wiki/Lock_dependency_information, 


       blocker_target        | blocker_pid | blocker_mode  | depth |           target            |  pid  |   mode    |     seq
-----------------------------+-------------+---------------+-------+-----------------------------+-------+-----------+-------------
 (virtualxid,,,,,1/2069,,,,) |       69466 | ExclusiveLock |     1 | (virtualxid,,,,,1/2069,,,,) | 69611 | ShareLock | 69466,69611

from pg_locks, I can only see locktype is virtualxid, and there is no relation info.
does anyone know why the blocking happens? I guess it might be blocked on system view or tables, but just guess.

thanks

James





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