Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1ow78O-0000fP-DK
	for pgsql-hackers@arkaria.postgresql.org; Fri, 18 Nov 2022 19:34:44 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1ow78N-0006Wb-7G
	for pgsql-hackers@arkaria.postgresql.org; Fri, 18 Nov 2022 19:34:43 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <bruce@momjian.us>)
	id 1ow78M-0006WR-VC
	for pgsql-hackers@lists.postgresql.org; Fri, 18 Nov 2022 19:34:42 +0000
Received: from momjian.us ([72.94.173.45])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <bruce@momjian.us>)
	id 1ow78K-0001i5-JG
	for pgsql-hackers@postgresql.org; Fri, 18 Nov 2022 19:34:42 +0000
Received: from bruce by momjian.us with local (Exim 4.94.2)
	(envelope-from <bruce@momjian.us>)
	id 1ow78E-006Ov2-G6; Fri, 18 Nov 2022 14:34:34 -0500
Date: Fri, 18 Nov 2022 14:34:34 -0500
From: Bruce Momjian <bruce@momjian.us>
To: Simon Riggs <simon.riggs@enterprisedb.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, Robert Treat <rob@xzilla.net>,
	Alvaro Herrera <alvherre@alvh.no-ip.org>,
	Erik Rijkers <er@xs4all.nl>, Justin Pryzby <pryzby@telsasoft.com>,
	PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: New docs chapter on Transaction Management and related changes
Message-ID: <Y3feSlJgVFwA74Go@momjian.us>
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>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CANbhV-Ex7eYvCY8_s-vTc-T_Vc4EzYtoe_vq2tQ9ebsPeFy_-g@mail.gmail.com>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/Y3feSlJgVFwA74Go%40momjian.us>
Precedence: bulk

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