Skip site navigation (1) Skip section navigation (2)

pgsql: Optimize commit_siblings in two ways to improve group commit.

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Optimize commit_siblings in two ways to improve group commit.
Date: 2010-12-08 18:51:36
Message-ID: E1PQP72-0001uS-0d@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
Optimize commit_siblings in two ways to improve group commit.
First, avoid scanning the whole ProcArray once we know there
are at least commit_siblings active; second, skip the check
altogether if commit_siblings = 0.

Greg Smith

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=e620ee35b249b0af255ef788003d1c9edb815a35

Modified Files
--------------
doc/src/sgml/config.sgml            |   17 ++++++++++++-----
src/backend/access/transam/xact.c   |    2 +-
src/backend/storage/ipc/procarray.c |   17 ++++++++++++-----
src/backend/utils/misc/guc.c        |    2 +-
src/include/storage/procarray.h     |    2 +-
5 files changed, 27 insertions(+), 13 deletions(-)

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2010-12-08 18:56:12
Subject: Re: [COMMITTERS] pgsql: Optimize commit_siblings in two ways to improve group commit.
Previous:From: Robert HaasDate: 2010-12-08 18:40:04
Subject: Re: Review: Extensions Patch

pgsql-committers by date

Next:From: Tom LaneDate: 2010-12-08 18:56:12
Subject: Re: [COMMITTERS] pgsql: Optimize commit_siblings in two ways to improve group commit.
Previous:From: User MhasegawaDate: 2010-12-08 06:55:02
Subject: pgbulkload - pgbulkload: backport two bugs.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group