Re: PostgreSQL performance on FreeBSD

From: Konstantin Belousov <kostikbel_at_gmail.com>
Date: Wed, 22 Jun 2016 13:02:41 +0300
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
sent.

> 
> 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.
Received on Wed Jun 22 2016 - 08:02:54 UTC

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