Postgres Pro
Downloads
Home   >   mailing lists

pg_locks - what is a virtualxid locktype - Mailing list pgsql-admin

From Mariel Cherkassky
Subject pg_locks - what is a virtualxid locktype
Date
Msg-id CA+t6e1kYrwvGYEh9FVMA7v=vZG0KB+xcu+KNaBvf6r9tzqLLkQ@mail.gmail.com
Whole thread Raw
Responses Re: pg_locks - what is a virtualxid locktype  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
Re: pg_locks - what is a virtualxid locktype  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
List pgsql-admin
Tree view
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 by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: : : How to mask column: :
Next
From: Shreeyansh Dba
Date:
Subject: Re: pg_locks - what is a virtualxid locktype