Re: CLOG contention - Mailing list pgsql-hackers

From Robert Haas
Subject Re: CLOG contention
Date
Msg-id CA+Tgmoa2yEk3tRGUvBUQxO0E0m93AcvcT9Bxpuw4uJC5yX1d2A@mail.gmail.com
Whole thread Raw
In response to Re: CLOG contention  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: CLOG contention  (Simon Riggs <simon@2ndQuadrant.com>)
Re: CLOG contention  (Merlin Moncure <mmoncure@gmail.com>)
Re: CLOG contention  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thu, Jan 5, 2012 at 11:10 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> Let's commit the change to 32.

I would like to do that, but I think we need to at least figure out a
way to provide an escape hatch for people without much shared memory.
We could do that, perhaps, by using a formula like this:

1 CLOG buffer per 128MB of shared_buffers, with a minimum of 8 and a
maximum of 32

I also think it would be a worth a quick test to see how the increase
performs on a system with <32 cores.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: CLOG contention
Next
From: Simon Riggs
Date:
Subject: Re: CLOG contention