flyusa2010 fly wrote:
> Hi, folks,
>
> in src/template/darwin:
>
> # Select appropriate semaphore support. Darwin 6.0 (Mac OS X 10.2) and up
> # support System V semaphores; before that we have to use POSIX semaphores,
> # which are less good for our purposes because they eat a file descriptor
> # per backend per max_connection slot.
>
> To my understanding, the number of descriptors created by POSIX semaphores
> would be # of actual clients times max_connection.
> However, I monitor the number of open files using sysctl, and I find that
> kern.num_files doesn't match the result calculated by the formula that is
> inferred by me...
>
> So, what would the number of file descriptors be, when using POSIX
> semaphore?
I thought the text was wrong, but this commit reinforces that text:
commit 93407d3998cc8717993dbc102f854a478985bc19Author: Tom Lane <tgl@sss.pgh.pa.us>Date: Wed Sep 26 00:32:46 2007
+0000 Use SYSV semaphores rather than POSIX on Darwin >= 6.0 (i.e., OS X 10.2 and up), per Chris Marcellino. This
avoids consuming O(N^2) file descriptors to support N backends. Tests suggest it's about a wash for small
installations,but large ones would have a problem.
What numbers are you seeing?
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ It's impossible for everything to be true. +