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

pgsql: Make the number of CLOG buffers adaptive,based on shared_buffer

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Make the number of CLOG buffers adaptive,based on shared_buffer
Date: 2012-01-06 19:33:15
Message-ID: E1RjFXP-0004gn-CT@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Make the number of CLOG buffers adaptive, based on shared_buffers.

Previously, this was hardcoded: we always had 8.  Performance testing
shows that isn't enough, especially on big SMP systems, so we allow it
to scale up as high as 32 when there's adequate memory.  On the flip
side, when shared_buffers is very small, drop the number of CLOG buffers
down to as little as 4, so that we can start the postmaster even
when very little shared memory is available.

Per extensive discussion with Simon Riggs, Tom Lane, and others on
pgsql-hackers.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/33aaa139e6302e81b4fbf2570be20188bb974c4f

Modified Files
--------------
src/backend/access/transam/clog.c |   33 +++++++++++++++++++++++++++++++--
src/backend/storage/lmgr/lwlock.c |    2 +-
src/include/access/clog.h         |    5 +----
3 files changed, 33 insertions(+), 7 deletions(-)

pgsql-committers by date

Next:From: Tom LaneDate: 2012-01-06 21:05:09
Subject: Re: [COMMITTERS] pgsql: Fix breakage from earlier plperl fix.
Previous:From: Andrew DunstanDate: 2012-01-06 19:13:41
Subject: Re: [COMMITTERS] pgsql: Fix breakage from earlier plperl fix.

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