> On Jun 24, 2020, at 6:47 AM, Peter J. Holzer <hjp-pg...@hjp.at> wrote: > > The default is 100. What was your reason for reducing it to such a low > value?
“PostgreSQL 9 High Availability” recommended core count * 3. > >> I’ve installed pg_stat_activity and pg_stat_statements. >> >> I access this server through a web app, > > So that's probably a handful connections already. Looks like 5 queries. As a comparison I have 37 queries asking for last login of a single user. No errors. (I increased the max_connections yesterday) >> and another client on two machines. > > Maybe two or more (depending on what the non-specified client does). I’m running crons on two machines, Postico, web apps on both machines. >> I also send queries through SSH on the LAN. > > And maybe some more connections. Yep. > I can see that this could easily reach 12 connections. Yep. But I can’t see all this going over 12 when connections close. Hence the confusion and issue. At least it’s a good thing I’m finding it’s not the gem alone. Cheers, Bee
