From: | tgl(at)postgresql(dot)org (Tom Lane) |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Divide the lock manager's shared state into 'partitions', so as |
Date: | 2005-12-11 21:02:18 |
Message-ID: | 20051211210218.750A99DCAC3@postgresql.org |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Log Message:
-----------
Divide the lock manager's shared state into 'partitions', so as to
reduce contention for the former single LockMgrLock. Per my recent
proposal. I set it up for 16 partitions, but on a pgbench test this
gives only a marginal further improvement over 4 partitions --- we need
to test more scenarios to choose the number of partitions.
Modified Files:
--------------
pgsql/src/backend/access/transam:
twophase.c (r1.17 -> r1.18)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/twophase.c.diff?r1=1.17&r2=1.18)
pgsql/src/backend/storage/ipc:
procarray.c (r1.8 -> r1.9)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/ipc/procarray.c.diff?r1=1.8&r2=1.9)
pgsql/src/backend/storage/lmgr:
README (r1.18 -> r1.19)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/lmgr/README.diff?r1=1.18&r2=1.19)
deadlock.c (r1.37 -> r1.38)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/lmgr/deadlock.c.diff?r1=1.37&r2=1.38)
lock.c (r1.161 -> r1.162)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/lmgr/lock.c.diff?r1=1.161&r2=1.162)
lwlock.c (r1.35 -> r1.36)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/lmgr/lwlock.c.diff?r1=1.35&r2=1.36)
proc.c (r1.169 -> r1.170)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/lmgr/proc.c.diff?r1=1.169&r2=1.170)
pgsql/src/include/storage:
lock.h (r1.92 -> r1.93)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/storage/lock.h.diff?r1=1.92&r2=1.93)
lwlock.h (r1.23 -> r1.24)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/storage/lwlock.h.diff?r1=1.23&r2=1.24)
proc.h (r1.84 -> r1.85)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/storage/proc.h.diff?r1=1.84&r2=1.85)
From | Date | Subject | |
---|---|---|---|
Next Message | User Sven | 2005-12-11 21:50:02 | wikipedia - wikipgedia: Sanitizer CSS comment processing order fix |
Previous Message | Neil Conway | 2005-12-11 10:54:28 | pgsql: Implement IS NOT DISTINCT FROM, update the regression tests and |