pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Bruce Momjian <bruce@momjian.us>
To: Simon Riggs <simon.riggs@enterprisedb.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Robert Treat <rob@xzilla.net>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Erik Rijkers <er@xs4all.nl>
Cc: Justin Pryzby <pryzby@telsasoft.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: New docs chapter on Transaction Management and related changes
Date: Fri, 18 Nov 2022 14:34:34 -0500
Message-ID: <Y3feSlJgVFwA74Go@momjian.us> (raw)
In-Reply-To: <CANbhV-Ex7eYvCY8_s-vTc-T_Vc4EzYtoe_vq2tQ9ebsPeFy_-g@mail.gmail.com>
References: <Y0iL7jzLfSbj1T38@momjian.us>
	<20221014084615.chvollxv3oz43oqu@alvherre.pgsql>
	<CANbhV-E287+hqhEbC7vCShT16LKYM8aUhrvxQZdjX2osKAETkQ@mail.gmail.com>
	<Y0m9tIrlMqaA9dwP@momjian.us>
	<CAJSLCQ32vZ8S+yFbO1bKbKT=JE8Q6oRJXeRqfN6Atk-XJKPr7g@mail.gmail.com>
	<Y0tZf7N+cUJ9ebPI@momjian.us>
	<80a5fd9c080d66e62f90c9565e3e1b54e61f584c.camel@cybertec.at>
	<CANbhV-GafnnLmyMmjwYGFFcspk_twoEO56M3jiB7D0p_TkUmZA@mail.gmail.com>
	<3603e6e85544daa5300c7106c31bc52673711cd0.camel@cybertec.at>
	<CANbhV-Ex7eYvCY8_s-vTc-T_Vc4EzYtoe_vq2tQ9ebsPeFy_-g@mail.gmail.com>

On Thu, Nov 10, 2022 at 11:31:25AM +0000, Simon Riggs wrote:
> > That's not true.  Transactions waiting for table-level locks are shown
> > waiting for a "relation" lock in both "pg_stat_activity" and "pg_locks".
> 
> Agreed.
> 
> Lock waits on table-locks are shown waiting for a lock type of
> <literal>relation</literal>,
> while lock waits on row-level locks are shown waiting for a lock type
> of <literal>transactionid</literal>.
> Table-level locks require only a virtualxid when the lock is less than an
> AccessExclusiveLock; in other cases an xid must be allocated.

Yeah, I went with more generic wording since the point seems to be that
sometimes xid and sometimes vxids are waited on.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Indecision is a decision.  Inaction is an action.  Mark Batterson






view thread (68+ messages)  latest in thread

Message-ID: <Y3feSlJgVFwA74Go@momjian.us>
Permalink:  ../Y3feSlJgVFwA74Go@momjian.us/
Also on:    postgresql.org/message-id/Y3feSlJgVFwA74Go@momjian.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: bruce@momjian.us, simon.riggs@enterprisedb.com, laurenz.albe@cybertec.at, rob@xzilla.net, alvherre@alvh.no-ip.org, er@xs4all.nl, pryzby@telsasoft.com
  Subject: Re: New docs chapter on Transaction Management and related changes
  In-Reply-To: <Y3feSlJgVFwA74Go@momjian.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox