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(-) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
