[pgpool-general: 3960] Re: accept() scalability issues
Michael Renner
michael.renner at amd.co.at
Thu Aug 13 22:18:43 JST 2015
> On 10 Aug 2015, at 11:25, Tatsuo Ishii <ishii at postgresql.org> wrote:
>
>> So if there’s nothing horribly wrong/out of the ordinary with our setup, I’d pretty much say that with a high number of children fencing around select/accept is dearly needed.
>
> Ok, here is the experimental patch to serialize select(2) for listen
> fds by using semaphore. Could you please try it out? The patch is
> against 3.3-stable.
Thank you very much, that worked fine!
In a synthetic test with 1000 children and ~30 connections per second this lowered the amount of context switches from ~38.000/sec to ~1.000/sec.
We’ll test it in production mid next week, will let you know how things go.
Best,
Michael
More information about the pgpool-general
mailing list