diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/catalogs.sgml | 4 | ||||
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 20 |
2 files changed, 21 insertions, 3 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index f314f93051d..96e55193f19 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -8886,7 +8886,8 @@ SCRAM-SHA-256$<replaceable><iteration count></>:<replaceable><salt>< and general database objects (identified by class OID and object OID, in the same way as in <structname>pg_description</structname> or <structname>pg_depend</structname>). Also, the right to extend a - relation is represented as a separate lockable object. + relation is represented as a separate lockable object, as is the right to + update <structname>pg_database</structname>.<structfield>datfrozenxid</structfield>. Also, <quote>advisory</> locks can be taken on numbers that have user-defined meanings. </para> @@ -8912,6 +8913,7 @@ SCRAM-SHA-256$<replaceable><iteration count></>:<replaceable><salt>< Type of the lockable object: <literal>relation</>, <literal>extend</>, + <literal>frozenid</literal>, <literal>page</>, <literal>tuple</>, <literal>transactionid</>, diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index c492114f331..601616ec2ce 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -845,7 +845,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser <tbody> <row> - <entry morerows="62"><literal>LWLock</></entry> + <entry morerows="64"><literal>LWLock</></entry> <entry><literal>ShmemIndexLock</></entry> <entry>Waiting to find or allocate space in shared memory.</entry> </row> @@ -1044,6 +1044,16 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser the oldest transaction id available to it.</entry> </row> <row> + <entry><literal>WrapLimitsVacuumLock</literal></entry> + <entry>Waiting to update limits on transaction id and multixact + consumption.</entry> + </row> + <row> + <entry><literal>NotifyQueueTailLock</literal></entry> + <entry>Waiting to update limit on notification message + storage.</entry> + </row> + <row> <entry><literal>clog</></entry> <entry>Waiting for I/O on a clog (transaction status) buffer.</entry> </row> @@ -1118,7 +1128,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser <entry>Waiting for TBM shared iterator lock.</entry> </row> <row> - <entry morerows="9"><literal>Lock</></entry> + <entry morerows="10"><literal>Lock</></entry> <entry><literal>relation</></entry> <entry>Waiting to acquire a lock on a relation.</entry> </row> @@ -1127,6 +1137,12 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser <entry>Waiting to extend a relation.</entry> </row> <row> + <entry><literal>frozenid</literal></entry> + <entry>Waiting to + update <structname>pg_database</structname>.<structfield>datfrozenxid</structfield> + and <structname>pg_database</structname>.<structfield>datminmxid</structfield>.</entry> + </row> + <row> <entry><literal>page</></entry> <entry>Waiting to acquire a lock on page of a relation.</entry> </row> |