]> granicus.if.org Git - postgresql/commit
Move "hot" members of PGPROC into a separate PGXACT array.
authorRobert Haas <rhaas@postgresql.org>
Fri, 25 Nov 2011 13:02:10 +0000 (08:02 -0500)
committerRobert Haas <rhaas@postgresql.org>
Fri, 25 Nov 2011 13:02:10 +0000 (08:02 -0500)
commited0b409d22346b1b027a4c2099ca66984d94b6dd
tree3d9942b4131ffa73cbf83735c3965b4c1fc7e307
parent9ed439a9c07b69c2617cc98596611fdbdc22472c
Move "hot" members of PGPROC into a separate PGXACT array.

This speeds up snapshot-taking and reduces ProcArrayLock contention.
Also, the PGPROC (and PGXACT) structures used by two-phase commit are
now allocated as part of the main array, rather than in a separate
array, and we keep ProcArray sorted in pointer order.  These changes
are intended to minimize the number of cache lines that must be pulled
in to take a snapshot, and testing shows a substantial increase in
performance on both read and write workloads at high concurrencies.

Pavan Deolasee, Heikki Linnakangas, Robert Haas
14 files changed:
src/backend/access/transam/twophase.c
src/backend/access/transam/varsup.c
src/backend/access/transam/xact.c
src/backend/commands/analyze.c
src/backend/commands/vacuum.c
src/backend/postmaster/postmaster.c
src/backend/replication/walsender.c
src/backend/storage/ipc/ipci.c
src/backend/storage/ipc/procarray.c
src/backend/storage/lmgr/deadlock.c
src/backend/storage/lmgr/lock.c
src/backend/storage/lmgr/proc.c
src/backend/utils/time/snapmgr.c
src/include/storage/proc.h