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(-)
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 |