pgsql-server/src backend/access/heap/heapam.c ...

CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: tgl(at)svr1(dot)postgresql(dot)org 04/04/21 15:24:27

Modified files:
src/backend/access/heap: heapam.c
src/backend/access/index: indexam.c
src/backend/access/nbtree: nbtinsert.c nbtpage.c nbtree.c
nbtsearch.c
src/backend/executor: nodeIndexscan.c nodeSeqscan.c
nodeTidscan.c
src/include/access: heapam.h nbtree.h

Log message:
Tweak indexscan and seqscan code to arrange that steps from one page to
the next are handled by ReleaseAndReadBuffer rather than separate
ReleaseBuffer and ReadBuffer calls. This cuts the number of acquisitions
of the BufMgrLock by a factor of 2 (possibly more, if an indexscan happens
to pull successive rows from the same heap page). Unfortunately this
doesn't seem enough to get us out of the recently discussed context-switch
storm problem, but it's surely worth doing anyway.