Re: Bump soft open file limit (RLIMIT_NOFILE) to hard limit on startup

Jelte Fennema-Nio <postgres@jeltef.nl>

From: "Jelte Fennema-Nio" <postgres@jeltef.nl>

To: "Andres Freund" <andres@anarazel.de>

Cc: "Tom Lane" <tgl@sss.pgh.pa.us>, "Tomas Vondra" <tomas@vondra.me>, "PostgreSQL-development" <pgsql-hackers@postgresql.org>

Date: 2025-02-24T09:56:23Z

Lists: pgsql-hackers

Attachments

v4-0001-Adds-a-helper-for-places-that-shell-out-to-system.patch (text/x-patch) patch v4-0001
v4-0002-Bump-postmaster-soft-open-file-limit-RLIMIT_NOFIL.patch (text/x-patch) patch v4-0002
v4-0003-Reflect-the-value-of-max_safe_fds-in-max_files_pe.patch (text/x-patch) patch v4-0003

On Thu Feb 20, 2025 at 1:37 AM CET, Andres Freund wrote:
> I've pushed this, with one trivial modification: I added %m to the error
> message in case setrlimit() fails. That's really unlikely to ever happen, but
> ...

Great! Attached are the updated other patches, I think I addressed all
feedback.

Commits

Redefine max_files_per_process to control additionally opened files
- adb5f85fa5a0 18.0 landed
pgbench: Increase RLIMIT_NOFILE if necessary
- d38bab5edd60 18.0 landed
Move extra code out of the Pre/PostRestoreCommand() section.
- 8fb13dd6ab5b 17.0 cited