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-03-17T23:08:03Z

Lists: pgsql-hackers

Attachments

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

On Mon Feb 24, 2025 at 12:01 PM CET, Jelte Fennema-Nio wrote:
> Right after pressing send I realized I could remove two more useless
> lines...

Rebased patchset attached (trivial conflict against pg_noreturn
changes).

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