Re: lazy_scan_heap() should release lock on buffer before vacuuming FSM
Robert Haas <robertmhaas@gmail.com>
From: Robert Haas <robertmhaas@gmail.com>
To: Andres Freund <andres@anarazel.de>
Cc: Melanie Plageman <melanieplageman@gmail.com>,
Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2023-11-16T20:52:10Z
Lists: pgsql-hackers
On Thu, Nov 16, 2023 at 3:49 PM Andres Freund <andres@anarazel.de> wrote: > I think the main reason it's not all that bad, even when hitting this path, is > that one stall every 8GB just isn't that much and that the stalls aren't that > long - the leaf page fsm updates don't use the strategy, so they're still > somewhat likely to be in s_b, and there's "just" ~2MB of FMS to read. I tried > to reproduce it here, and it was a few ms, even though I dropped filesystem > caches in a loop. So just fix it in master then. If it turns out later there are worse scenarios, you can back-patch then. -- Robert Haas EDB: http://www.enterprisedb.com
Commits
-
Release lock on heap buffer before vacuuming FSM
- b2e237afddc5 17.0 landed