Re: pgsql: aio: Infrastructure for io_method=worker
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@anarazel.de>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2025-03-18T22:53:48Z
Lists: pgsql-hackers
Andres Freund <andres@anarazel.de> writes: > To allow the number of IO workers to be increased without a restart, we need > to reserve PGPROC entries for the workers unconditionally. This has been > judged to be worth the cost. If it turns out to be problematic, we can > introduce a PGC_POSTMASTER GUC to control the maximum number. So I see this patch added 32 PGPROCs and hence 32 semaphores to the system's requirements. Unsurprisingly, this broke OpenBSD/NetBSD again: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=sawshark&dt=2025-03-18%2016%3A20%3A05 It's probably time to just abandon the idea of being able to run with only 60 semaphores. I wonder though if we ought to revert 38da05346 and/or 6d0154196 in view of that. regards, tom lane
Commits
-
Give up on running with NetBSD/OpenBSD's default semaphore settings.
- 810a8b1c8051 18.0 landed
-
aio: Infrastructure for io_method=worker
- 55b454d0e140 18.0 cited