pg_locks - what is a virtualxid locktype

From: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org, PostgreSQL mailing lists <pgsql-performance(at)postgresql(dot)org>
Subject: pg_locks - what is a virtualxid locktype
Date: 2019-01-29 08:57:11
Message-ID: CA+t6e1kYrwvGYEh9FVMA7v=vZG0KB+xcu+KNaBvf6r9tzqLLkQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

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 ?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shreeyansh Dba 2019-01-29 09:33:17 Re: pg_locks - what is a virtualxid locktype
Previous Message Achilleas Mantzios 2019-01-29 08:55:52 Re: : : How to mask column: :

Browse pgsql-performance by date

  From Date Subject
Next Message Nicolas Charles 2019-01-29 09:14:13 Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?
Previous Message Saurabh Nanda 2019-01-29 06:15:08 Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?