Re: [PATCH] PostgreSQL 9.4 mmap(2) performance regression on FreeBSD...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PATCH] PostgreSQL 9.4 mmap(2) performance regression on FreeBSD...
Дата
Msg-id 477.1413212487@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PATCH] PostgreSQL 9.4 mmap(2) performance regression on FreeBSD...  (Sean Chittenden <sean@chittenden.org>)
Ответы Re: [PATCH] PostgreSQL 9.4 mmap(2) performance regression on FreeBSD...
Список pgsql-hackers
Sean Chittenden <sean@chittenden.org> writes:
> In the same breath, it would also be nice if the following were committed:
> [ use named POSIX semaphores on FreeBSD ]

Really?  Why?  According to the notes in our code, named POSIX semaphores
are the least attractive of the three Unixoid semaphore APIs we support,
because they require eating a file descriptor per backend per
max_connection slot.  That's a lot of FDs in any large configuration.
FreeBSD's support for SysV semaphores would have to be pretty darn awful
to make me think this was a good change, and I've not heard complaints
in that direction before.

If you meant to propose using *unnamed* POSIX semaphores, that might be
a reasonable change, but it would still need some supporting evidence.
        regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Hide 'Execution time' in EXPLAIN (COSTS OFF)
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [9.4 bug] The database server hangs with write-heavy workload on Windows