Thomas Munro writes:
> Cool. BTW small correction to something I said about FreeBSD: it'd be
> better to document the new name kern.ipc.soacceptqueue (see listen(2)
> HISTORY) even though the old name still works and matches OpenBSD and
> macOS.
Thanks. Sounds like we get to document at least t
On Mon, Aug 22, 2022 at 2:18 PM Tom Lane wrote:
> Thomas Munro writes:
> > On Mon, Aug 22, 2022 at 12:20 PM Tom Lane wrote:
> >> Hmm. It'll be awhile till the 128 default disappears entirely
> >> though, especially if assorted BSDen use that too. Probably
> >> worth the trouble to document.
>
Thomas Munro writes:
> On Mon, Aug 22, 2022 at 12:20 PM Tom Lane wrote:
>> Hmm. It'll be awhile till the 128 default disappears entirely
>> though, especially if assorted BSDen use that too. Probably
>> worth the trouble to document.
> I could try to write a doc patch if you aren't already on
On Mon, Aug 22, 2022 at 12:20 PM Tom Lane wrote:
> Thomas Munro writes:
> > Yeah retrying doesn't seem that nice. +1 for a bit of documentation,
> > which I guess belongs in the server tuning part where we talk about
> > sysctls, perhaps with a link somewhere near max_connections? More
> > rece
Thomas Munro writes:
> Yeah retrying doesn't seem that nice. +1 for a bit of documentation,
> which I guess belongs in the server tuning part where we talk about
> sysctls, perhaps with a link somewhere near max_connections? More
> recent Linux kernels bumped it to 4096 by default so I doubt it'
On Mon, Aug 22, 2022 at 10:55 AM Tom Lane wrote:
> Not sure what I think at this point about making libpq retry after
> EAGAIN. It would make sense for this particular undocumented use
> of EAGAIN, but I'm worried about others, especially the documented
> reason. On the whole I'm inclined to lea
Thomas Munro writes:
> If it's something like that, maybe increasing
> /proc/sys/net/core/somaxconn would help? I think older kernels only
> had 128 here.
Bingo! I see
$ cat /proc/sys/net/core/somaxconn
128
by default, which is right about where the problem starts. After
$ sudo sh -c 'echo
Hi,
On 2022-08-21 17:15:01 -0400, Tom Lane wrote:
> I tried to duplicate this behavior locally (on RHEL8) and got something
> interesting. After increasing the server's max_connections to 1000,
> I can do
>
> $ pgbench -S -c 200 -j 100 -t 100 bench
>
> and it goes through fine. But:
>
> $ pgbenc
On Mon, Aug 22, 2022 at 9:48 AM Tom Lane wrote:
> It's also pretty unclear why the kernel would want to return
> EAGAIN instead of letting the nonblock connection path do the
> waiting, which is why I'm suspecting a bug rather than designed
> behavior.
Could it be that it fails like that if the l
Andrew Dunstan writes:
> On 2022-08-21 Su 17:15, Tom Lane wrote:
>> On the whole this is smelling more like a Linux kernel bug than
>> anything else.
> *nod*
Conceivably we could work around this in libpq: on EAGAIN, just
retry the failed connect(), or maybe better to close the socket
and take i
On 2022-08-21 Su 17:15, Tom Lane wrote:
> Andrew Dunstan writes:
>> On 2022-08-20 Sa 23:20, Tom Lane wrote:
>>> Kevin McKibbin writes:
What's limiting my DB from allowing more connections?
>> The first question in my mind from the above is where this postgres
>> instance is actually listen
Andrew Dunstan writes:
> On 2022-08-20 Sa 23:20, Tom Lane wrote:
>> Kevin McKibbin writes:
>>> What's limiting my DB from allowing more connections?
> The first question in my mind from the above is where this postgres
> instance is actually listening. Is it really /var/run/postgresql? Its
> pos
On 2022-08-20 Sa 23:20, Tom Lane wrote:
> Kevin McKibbin writes:
>> What's limiting my DB from allowing more connections?
>> This is a sample of the output I'm getting, which repeats the error 52
>> times (one for each failed connection)
>> -bash-4.2$ pgbench -c 200 -j 200 -t 100 benchy
>> ...
>
Sorry Tom for the duplicate email. Resending with the mailing list.
> Thanks for your response. I'm using a Centos Linux environment and have
> the open files set very high:
>
> -bash-4.2$ ulimit -a|grep open
> open files (-n) 65000
>
> What else could be limiting the connect
14 matches
Mail list logo
