pgsql: Extend relations multiple blocks at a time to improve scalabilit

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Extend relations multiple blocks at a time to improve scalabilit
Date: 2016-04-08 06:08:00
Message-ID: E1aoPaK-0001Ak-Vv@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2016-04-08 06:39:48 pgsql: Use quicksort, not replacement selection, for external sorting.
Previous Message Fujii Masao 2016-04-08 04:25:36 pgsql: Fix a couple of places in doc that implied there was only one sy