pgsql: Extend relations multiple blocks at a time to improve scalabilit - Mailing list pgsql-committers

From Robert Haas
Subject pgsql: Extend relations multiple blocks at a time to improve scalabilit
Date
Msg-id E1aoPaK-0001Ak-Vv@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Extend relations multiple blocks at a time to improve scalability.

Contention on the relation extension lock can become quite fierce when
multiple processes are inserting data into the same relation at the same
time at a high rate.  Experimentation shows the extending the relation
multiple blocks at a time improves scalability.

Dilip Kumar, reviewed by Petr Jelinek, Amit Kapila, and me.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/719c84c1be51f3d3fe6049b77ddbaa0c4b58a9a9

Modified Files
--------------
src/backend/access/heap/hio.c             | 112 +++++++++++++++++++++++++++++-
src/backend/storage/freespace/freespace.c |  81 +++++++++++++++++++++
src/backend/storage/lmgr/lmgr.c           |  35 ++++++++++
src/backend/storage/lmgr/lock.c           |  37 ++++++++++
src/include/storage/freespace.h           |   4 ++
src/include/storage/lmgr.h                |   3 +
src/include/storage/lock.h                |   2 +
7 files changed, 271 insertions(+), 3 deletions(-)


pgsql-committers by date:

Previous
From: Fujii Masao
Date:
Subject: pgsql: Fix a couple of places in doc that implied there was only one sy
Next
From: Robert Haas
Date:
Subject: pgsql: Use quicksort, not replacement selection, for external sorting.