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-24T10:58:53Z

Lists: pgsql-hackers

Attachments

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

On Mon Feb 24, 2025 at 10:56 AM CET, Jelte Fennema-Nio wrote:
> Great! Attached are the updated other patches, I think I addressed all
> feedback.

Ughh, a compiler warning snuck on windows during some of my final
refactoring. Fixed now.

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