| From: | Tatsuya Kawata <kawatatatsuya0913(at)gmail(dot)com> |
|---|---|
| To: | Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | [PATCH] doc: clarify pg_stat_lock.fastpath_exceeded scope |
| Date: | 2026-06-13 04:15:49 |
| Message-ID: | CAHza6qdKo9dcPy70QBi88vpqhS2gYWViS8=Uj=-+QQbR=ONgSQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
While developing the pg_stat_lock improvement proposed in (*1), I
noticed that the documentation of the fastpath_exceeded column in
pg_stat_lock could be more explicit about its scope.
The current documentation describes it as:
Number of times a lock of this type could not be acquired via fast
path because the fast path slot limit was exceeded. Increasing
max_locks_per_transaction can reduce this number.
This omits the fact that fast-path locking only applies to relation
locks acquired in the weak modes (AccessShareLock, RowShareLock,
RowExclusiveLock), so the counter is always zero for any other
locktype.
The attached patch adds a short clarification to the pg_stat_lock entry
in monitoring.sgml.
(*1) [PATCH] pg_stat_lock: add blocker mode dimension
https://www.postgresql.org/message-id/flat/CAHza6qeixfLeM3AqEkjgkE%2BBAqxB%3D5p227fo6JR60cG4mj8O8A%40mail.gmail.com#3592fb428248b200452b900468dc6d65
Regards,
Tatsuya Kawata
| Attachment | Content-Type | Size |
|---|---|---|
| v1-0001-doc-clarify-pg_stat_lock.fastpath_exceeded-scope.patch | application/octet-stream | 1.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chao Li | 2026-06-13 06:01:40 | Re: Fix SET EXPRESSION for virtual columns with whole-row dependencies |
| Previous Message | Tatsuya Kawata | 2026-06-13 03:13:04 | Re: [PATCH] pg_stat_lock: add blocker mode dimension |