Re: New docs chapter on Transaction Management and related changes - Mailing list pgsql-hackers

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