pgsql: Make parallel nbtree index scans use an LWLock. - Mailing list pgsql-committers

From Peter Geoghegan
Subject pgsql: Make parallel nbtree index scans use an LWLock.
Date
Msg-id E1tqwlb-001Ro2-1X@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Make parallel nbtree index scans use an LWLock.

Teach parallel nbtree index scans to use an LWLock (not a spinlock) to
protect the scan's shared descriptor state.

Preparation for an upcoming patch that will add skip scan optimizations
to nbtree.  That patch will create the need to occasionally allocate
memory while the scan descriptor is locked, while copying datums that
were serialized by another backend.

Author: Peter Geoghegan <pg@bowt.ie>
Reviewed-By: Matthias van de Meent <boekewurm+postgres@gmail.com>
Discussion: https://postgr.es/m/CAH2-Wz=PKR6rB7qbx+Vnd7eqeB5VTcrW=iJvAsTsKbdG+kW_UA@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/67fc4c9fd7fab7004b656e0cc27826c75d7ea7ad

Modified Files
--------------
src/backend/access/nbtree/nbtpreprocesskeys.c   |  2 +-
src/backend/access/nbtree/nbtree.c              | 27 +++++++++++++------------
src/backend/storage/lmgr/lwlock.c               |  1 +
src/backend/utils/activity/wait_event_names.txt |  1 +
src/include/storage/lwlock.h                    |  1 +
5 files changed, 18 insertions(+), 14 deletions(-)


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pgsql: Generalize hash and ordering support in amapi
Next
From: Tom Lane
Date:
Subject: pgsql: Clear errno before calling strtol() in spell.c.