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