Re: [PATCH] doc: clarify pg_stat_lock.fastpath_exceeded scope - Mailing list pgsql-hackers

From Tatsuya Kawata
Subject Re: [PATCH] doc: clarify pg_stat_lock.fastpath_exceeded scope
Date
Msg-id CAHza6qej7PATweXhE-Q3ihZGtWgdoNEjC==FLeaNF_4r6+PEgg@mail.gmail.com
Whole thread
In response to Re: [PATCH] doc: clarify pg_stat_lock.fastpath_exceeded scope  (Bertrand Drouvot <bertranddrouvot.pg@gmail.com>)
Responses Re: [PATCH] doc: clarify pg_stat_lock.fastpath_exceeded scope
List pgsql-hackers
Hi Bertrand-san,

Thanks for the review.

> Should we add a description of the consequences of not being able to
> acquire the lock in fast-path (when there are no available slots)?
> For example, we could say that this is considerably more expensive
> and may be subject to contention.

Agreed.  v3 adds the following paragraph at the end of the Fast-Path Locking subsection:

+     <para>
+      Acquiring a lock via the main lock table is considerably more
+      expensive than the fast path, and under heavy concurrent lock
+      activity can become a point of contention (observable as the
+      <literal>LockManager</literal> wait event).
+     </para>

Other parts of the patch are unchanged from v2.
v3 attached.

Regards,
Tatsuya Kawata

Attachment

pgsql-hackers by date:

Previous
From: Nishant Sharma
Date:
Subject: Re: [PATCH] Add support for SAOP in the optimizer for partial index paths
Next
From: Matthias van de Meent
Date:
Subject: Re: TID recycling race during nbtree index-only scans that run on a standby