pgbench performance is lagging compared to Linux and DragonflyBSD?

[Samuel J. Greear]

On Tue, Nov 6, 2012 at 2:01 PM, Yuri <yuri at rawbw.com> wrote:
> On 11/06/2012 11:10, Samuel J. Greear wrote:
>>
>> Single and multi-socket hardware are not really directly comparable in
>> PostgreSQL tests.
>
>
> So if the CPUs are split between sockets, would such system generally
> perform better or worse with PostgeSQL vs. non-split situation?
>
> Yuri

Unless the algorithms you are testing are able to operate entirely out
of the processors caches (and PostgreSQL does not fall into that
category) performance will be generally lower as you add sockets.
FreeBSD's ULE scheduler is aware of this and takes it into account,
but the performance ULE is able to maintain across sockets (this
applies to other OS's schedulers too) is more damage control than
anything else.

Sam