Re: Straightforward changes for increased SMP scalability

From: "Zeugswetter Andreas ADI SD" <Andreas(dot)Zeugswetter(at)s-itsolutions(dot)at>
To: "Strong, David" <david(dot)strong(at)unisys(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, "Simon Riggs" <simon(at)2ndquadrant(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Straightforward changes for increased SMP scalability
Date: 2007-07-17 10:00:30
Message-ID: E1539E0ED7043848906A8FF995BDA57902366672@m0143.s-mxs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message ohp 2007-07-17 13:19:29 Backend memory growing too much
Previous Message Oleg Bartunov 2007-07-17 09:58:46 Re: Updated tsearch documentation