[COMMITTERS] pgsql: Avoid SnapshotResetXmin() during AtEOXact_Snapshot()
От | Simon Riggs |
---|---|
Тема | [COMMITTERS] pgsql: Avoid SnapshotResetXmin() during AtEOXact_Snapshot() |
Дата | |
Msg-id | E1cw6dr-0008Ml-NV@gemulon.postgresql.org обсуждение исходный текст |
Ответы |
Re: [COMMITTERS] pgsql: Avoid SnapshotResetXmin() during AtEOXact_Snapshot()
Re: [COMMITTERS] pgsql: Avoid SnapshotResetXmin() during AtEOXact_Snapshot() |
Список | pgsql-committers |
Avoid SnapshotResetXmin() during AtEOXact_Snapshot() For normal commits and aborts we already reset PgXact->xmin, so we can simply avoid running SnapshotResetXmin() twice. During performance tests by Alexander Korotkov, diagnosis by Andres Freund showed PgXact array as a bottleneck. After manual analysis by me of the code paths that touch those memory locations, I was able to identify extraneous code in the main transaction commit path. Avoiding touching highly contented shmem improves concurrent performance slightly on all workloads, confirmed by tests run by Ashutosh Sharma and Alexander Korotkov. Simon Riggs Discussion: CANP8+jJdXE9b+b9F8CQT-LuxxO0PBCB-SZFfMVAdp+akqo4zfg@mail.gmail.com Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/6bad580d9e678a0b604883e14d8401d469b06566 Modified Files -------------- src/backend/access/transam/xact.c | 6 +++--- src/backend/utils/time/snapmgr.c | 14 ++++++++++++-- src/include/utils/snapmgr.h | 2 +- 3 files changed, 16 insertions(+), 6 deletions(-)
В списке pgsql-committers по дате отправления: