Re: PostgreSQL performance on FreeBSD

From: Maxim Sobolev <sobomax_at_freebsd.org>
Date: Tue, 21 Jun 2016 12:48:00 -0700
Thanks, Konstantin for the great work, we are definitely looking forward to
get all those improvements to be part of the default FreeBSD kernel/port.
Would be nice if you can post an update some day later as to what's
integrated and what's not.

Just in case, I've opened #14206 with PG to switch us to using POSIX
semaphores by default. Apart from the mentioned performance benefits, SYSV
semaphores are PITA to deal with as they come in very limited quantities by
default. Also they might stay around if PG dies/gets nuked and prevent it
from starting again due to overflow. We've got some quite ugly code to
clean up those using ipcrm(1) in our build scripts to deal with just that.
I am happy that code could be retired now.

-Maxim

On Fri, Jun 3, 2016 at 11:53 AM, John Baldwin <jhb_at_freebsd.org> wrote:

> On Friday, June 03, 2016 11:29:03 AM Adrian Chadd wrote:
> > On 3 June 2016 at 11:27, Adrian Chadd <adrian_at_freebsd.org> wrote:
> >
> > > That and the other NUMA stuff is something to address in -12.
> >
> > And, I completely welcome continued development in NUMA scaling in
> > combination with discussion. The iterator changes I committed are a
> > more generic version of a patch people were applying on top of -10 and
> > -head for at least what, three years now? Maybe more if -9 also just
> > did round-robin and not first-touch?
>
> 8 and 9 did first-touch.  Only 10 did round-robin.
>
> --
> John Baldwin
> _______________________________________________
> freebsd-current_at_freebsd.org mailing list
> https://lists.freebsd.org/mailman/listinfo/freebsd-current
> To unsubscribe, send any mail to "freebsd-current-unsubscribe_at_freebsd.org"
>
>
Received on Tue Jun 21 2016 - 17:48:01 UTC

This archive was generated by hypermail 2.4.0 : Wed May 19 2021 - 11:41:06 UTC