Re: Straightforward changes for increased SMP scalability - Mailing list pgsql-hackers

From Zeugswetter Andreas ADI SD
Subject Re: Straightforward changes for increased SMP scalability
Date
Msg-id E1539E0ED7043848906A8FF995BDA57902366672@m0143.s-mxs.net
Whole thread Raw
In response to Re: Straightforward changes for increased SMP scalability  ("Strong, David" <david.strong@unisys.com>)
List pgsql-hackers
> The NUM_BUFFER_PARTITIONS patch is fairly simple. We've
> noticed gains with NUM_BUFFER_PARTITIONS set between 256 and
> 2048, but little to no gain after 2048, although this might
> depend on the benchmark and platform being used. We've

Might this also be a padding issue, because 2048 partitions seems mighty
high ?
Other db's seem to cope well with a max of 64 partitions.

Andreas


pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Updated tsearch documentation
Next
From: Tom Lane
Date:
Subject: Re: plpgsql FOR loop doesn't guard against strange step values