Re: Scaling shared buffer eviction - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Scaling shared buffer eviction
Date
Msg-id 542D85BA.7080303@vmware.com
Whole thread Raw
In response to Re: Scaling shared buffer eviction  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Scaling shared buffer eviction
List pgsql-hackers
On 10/02/2014 05:40 PM, Robert Haas wrote:
> On Thu, Oct 2, 2014 at 10:36 AM, Andres Freund <andres@2ndquadrant.com> wrote:
>>> OK.
>>
>> Given that the results look good, do you plan to push this?
>
> By "this", you mean the increase in the number of buffer mapping
> partitions to 128, and a corresponding increase in MAX_SIMUL_LWLOCKS?

Hmm, do we actually ever need to hold all the buffer partition locks at 
the same time? At a quick search for NUM_BUFFER_PARTITIONS in the code, 
I couldn't find any place where we'd do that. I bumped up 
NUM_BUFFER_PARTITIONS to 128, but left MAX_SIMUL_LWLOCKS at 100, and did 
"make check". It passed.

- Heikki




pgsql-hackers by date:

Previous
From: Harold Giménez
Date:
Subject: Re: DDL Damage Assessment
Next
From: Andres Freund
Date:
Subject: Re: Scaling shared buffer eviction