Re: pg_locks - what is a virtualxid locktype
| От | Shreeyansh Dba |
|---|---|
| Тема | Re: pg_locks - what is a virtualxid locktype |
| Дата | |
| Msg-id | CAGDYbUP6O3uhe=X2m5VPVj-Z3a5_Dh+WtZPJYTMud0h+NKW72A@mail.gmail.com обсуждение исходный текст |
| Ответ на | pg_locks - what is a virtualxid locktype (Mariel Cherkassky <mariel.cherkassky@gmail.com>) |
| Ответы |
Re: pg_locks - what is a virtualxid locktype
Re: pg_locks - what is a virtualxid locktype |
| Список | pgsql-admin |
The virtualxid lock is special. It’s a exclusive lock on the transaction’s own virtual transaction ID that every transaction always holds. No other transaction can ever acquire it while the transaction is running.
The purpose of this is to allow one transaction to wait until another transaction commits or rolls back using PostgreSQL’s locking mechanism, and it’s used internally.
On Tue, Jan 29, 2019 at 2:27 PM Mariel Cherkassky <mariel.cherkassky@gmail.com> wrote:
Hey,I noticed that pg_locks has an addition row for every transaction that is created with a locktype "virtualxid". Tried to search it online but I didnt find an explanation for this behavior. Does anyone can explain why it happens ?
В списке pgsql-admin по дате отправления: