Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD - Mailing list pgsql-hackers

From Francois Tigeot
Subject Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD
Date
Msg-id 20140420101955.GA1824@sekishi.zefyris.com
Whole thread Raw
In response to Perfomance degradation 9.3 (vs 9.2) for FreeBSD  (Palle Girgensohn <girgen@FreeBSD.org>)
Responses Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD  (Palle Girgensohn <girgen@pingpong.net>)
List pgsql-hackers
Hi,

On Sun, Apr 20, 2014 at 11:24:38AM +0200, Palle Girgensohn wrote:
> 
> I see performance degradation with PostgreSQL 9.3 vs 9.2 on FreeBSD, and I'm wondering who to poke to mitigate the
problem.In reference to this thread [1], who where the FreeBSD people that Francois mentioned?
 

At least one FreeBSD hacker came to discuss it on the #dragonflybsd irc
channel and tried to run the benchmark on a 80-core machine.

I didn't keep logs and don't remember his/their name(s) but there was
definitely some FreeBSD effort at the time to investigate and fix things.

> If mmap needs to perform well in the kernel, I'd like to know of someone with FreeBSD kernel knowledge who is
interestedin working with mmap perfocmance. If mmap is indeed the cuplrit, I've just tested 9.2.8 vs 9.3.4, I nevere
isolatedthe 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

-- 
Francois Tigeot



pgsql-hackers by date:

Previous
From: Palle Girgensohn
Date:
Subject: Perfomance degradation 9.3 (vs 9.2) for FreeBSD
Next
From: Palle Girgensohn
Date:
Subject: Re: Perfomance degradation 9.3 (vs 9.2) for FreeBSD