MIME-Version: 1.0
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Fri, 13 Dec 2024 11:35:55 -0500
Message-ID: 
 <CANzqJaCicbLFV9emsTQO4mJGdGVkCo7F5Un6oUacjqOSSEj7fA@mail.gmail.com>
Subject: Benefit to increasing max_files_per_process?
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000006b4b1e0629296ddd"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaCicbLFV9emsTQO4mJGdGVkCo7F5Un6oUacjqOSSEj7fA%40mail.gmail.com>
Precedence: bulk

--0000000000006b4b1e0629296ddd
Content-Type: text/plain; charset="UTF-8"

PG 14.13 on RHEL 8.10

max_files_per_process is the default 1000.

Currently, many connection processes are hovering around 990 open files.

Does PG purposefully close some unused files when getting near the max?
Would we see benefits to increasing max_files_per_process as well as
running "ulimit -n 2500" (and then of course restarting PG).

I don't see any "too many open files" errors in the log file, but am trying
to plan ahead.

-- 
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--0000000000006b4b1e0629296ddd
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>PG 14.13 on RHEL 8.10</div><div><br></div><div>max_fi=
les_per_process is the default 1000.</div><div><br></div><div>Currently, ma=
ny connection processes are hovering around 990 open files.</div><div><br><=
/div><div>Does PG purposefully close some unused files when getting near th=
e max?=C2=A0 Would we see benefits to increasing max_files_per_process as w=
ell as running &quot;ulimit -n 2500&quot; (and then of course restarting PG=
).</div><div><br></div><div>I don&#39;t see any &quot;too many open files&q=
uot; errors in the log file, but am trying to plan ahead.</div><div><br></d=
iv><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" cl=
ass=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"=
>Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;=
m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div></div></di=
v></div></div>

--0000000000006b4b1e0629296ddd--