Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD

From: Palle Girgensohn <girgen(at)pingpong(dot)net>
To: Francois Tigeot <ftigeot(at)wolfpond(dot)org>
Cc: Palle Girgensohn <girgen(at)FreeBSD(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>
Subject: Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD
Date: 2014-04-21 10:58:01
Message-ID: 83A8B08D-6922-4ACC-BFA8-EA73EC9B03B7@pingpong.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 21 apr 2014 kl. 11:26 skrev Francois Tigeot <ftigeot(at)wolfpond(dot)org>:
>
>> On Sun, Apr 20, 2014 at 04:07:25PM +0200, Palle Girgensohn wrote:
>>
>>>> If mmap needs to perform well in the kernel, I'd like to know of someone with FreeBSD kernel knowledge who is interested in working with mmap perfocmance. If mmap is indeed the cuplrit, I've just tested 9.2.8 vs 9.3.4, I nevere isolated the mmap patch, although I believe Francois did just that with similar results.
>>>
>>> I did test the 9.3 -devel branch before and after the SysV shared memory =>
>>> mmap commit. The performance degradation was visible.
>>>
>>> I recently ran a few benchmarks of PostgreSQL 9.3 with different operating systems
>>> including DragonFly 3.6 and FreeBSD 10. You may be interested in the results:
>>>
>>> http://lists.dragonflybsd.org/pipermail/users/2014-March/128216.html
>>
>> Interesting, indeed. The fixes to dragonfly where made quite recently, in 3.2, right?
>
> The most important fixes occured in the 3.1 development version, around
> September 2012.
>
> There was definitely more than an isolated patch; the new scheduler was only
> part of the performance improvements.
> I'm afraid none of the commits would be applicable as-is to FreeBSD 10.x; the
> DragonFly kernel is vastly different in locking, threading and VM management.
>
> The FreeBSD folks should know what to do though; I collected performance
> counter data during the last benchmark run and sent it to adrian(at)(dot)
> It was also discussed on freebsd-performance; the thread begins here:
> http://lists.freebsd.org/pipermail/freebsd-performance/2014-March/004770.html
>

Great, thanks for the pointers!

Palle

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2014-04-21 11:10:01 Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD
Previous Message Francois Tigeot 2014-04-21 09:26:43 Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD