PostgreSQL performance on FreeBSD
kostikbel at gmail.com
Wed Jun 22 10:02:54 UTC 2016
On Tue, Jun 21, 2016 at 12:48:00PM -0700, Maxim Sobolev wrote:
> 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.
I did posted the update several days earlier. Since you replying to this
thread, it would be not unreasonable to read recent messages that were
> 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.
Named semaphores also stuck around if processes are killed without cleanup.
More information about the freebsd-performance