On 2024-12-16 Mo 12:23 AM, Tom Lane wrote:
Alexander Lakhin <exclusion@gmail.com> writes:
I deployed OpenBSD 7.4 locally and reproduced "too many clients" and that
hang as well. It turned out that OpenBSD has semmns as low as 60 (see [4])
and as a consequence, initdb sets max_connections = 20 for the regression
test database. (This can be helpful sometimes, see e.g., [5].) At the same
time, paralell_schedule contains groups of 20 tests, for instance:
Yeah. That was more-or-less okay before we invented parallel query,
but now there needs to be some headroom. I've thought about adjusting
initdb to not allow max_connections less than 25 (can't remember if
I actually proposed that on-list though). The other way would be to
rearrange parallel_schedule to make the max group size less than 20,
but that seems like a lot of effort for little benefit.
25 seems perfectly reasonable, these days. The current minimum was set nearly 7 years ago.
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
