MIME-Version: 1.0
References: 
 <CAGc_7H=OAK6sf0EEMv-_9fcAM76UFT=BzzfWs-sTSjsFj43vEA@mail.gmail.com>
 <bf0d57fcfe07c19c204e6b117c489414aa3514ba.camel@cybertec.at>
In-Reply-To: <bf0d57fcfe07c19c204e6b117c489414aa3514ba.camel@cybertec.at>
From: mahamood hussain <hussain.ieg@gmail.com>
Date: Tue, 26 May 2026 11:06:53 +0530
Message-ID: 
 <CAGc_7H=fZo7TV+uJApkwuMv1+zbTOS+wodZxzTR6YbpH2O-GZQ@mail.gmail.com>
Subject: Re: Request for Guidance on Recommended ulimit/Open File Settings for
 PostgreSQL 17 Multi-Cluster Environment
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a39b4f0652b1e226"
Archived-At: 
 <https://www.postgresql.org/message-id/CAGc_7H%3DfZo7TV%2BuJApkwuMv1%2BzbTOS%2BwodZxzTR6YbpH2O-GZQ%40mail.gmail.com>
Precedence: bulk

--000000000000a39b4f0652b1e226
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thank you for your response.

How can I determine whether the current setting is sufficient and verify
that I=E2=80=99m not hitting any limits with the existing value?

On Tue, May 26, 2026 at 2:33=E2=80=AFAM Laurenz Albe <laurenz.albe@cybertec=
.at>
wrote:

> On Mon, 2026-05-25 at 22:46 +0530, mahamood hussain wrote:
> > Current DB2 Setting:
> > Max open files =3D 65535
> > We would like clarification on:
> >    1. Is increasing the open file limit (ulimit -n) recommended/require=
d
> for PostgreSQL in such
> >       multi-cluster production environments?
>
> 65535 will be more than you need, unless you plan to use thousands of
> partitions or processes,
> which is a bad idea anyway.
>
> >    2. What would be the recommended LimitNOFILE value for PostgreSQL
> considering:multiple clusters
> >       on same hostproduction workloadsPgBouncer usageETL-heavy processi=
ng
>
> It all depends on how many files (tables, indexes) you plan to use.  If
> you are worried,
> just set the limit higher.
>
> Yours,
> Laurenz Albe
>

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

<div dir=3D"ltr">Thank you for your response.=C2=A0<div><p>How can I determ=
ine whether the current setting is sufficient and verify that I=E2=80=99m n=
ot hitting any limits with the existing value?</p></div></div><br><div clas=
s=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_att=
r">On Tue, May 26, 2026 at 2:33=E2=80=AFAM Laurenz Albe &lt;<a href=3D"mail=
to:laurenz.albe@cybertec.at">laurenz.albe@cybertec.at</a>&gt; wrote:<br></d=
iv><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bord=
er-left:1px solid rgb(204,204,204);padding-left:1ex">On Mon, 2026-05-25 at =
22:46 +0530, mahamood hussain wrote:<br>
&gt; Current DB2 Setting:<br>
&gt; Max open files =3D 65535<br>
&gt; We would like clarification on:<br>
&gt; =C2=A0=C2=A0=C2=A01. Is increasing the open file limit (ulimit -n) rec=
ommended/required for PostgreSQL in such<br>
&gt;=C2=A0 =C2=A0 =C2=A0 =C2=A0multi-cluster production environments?<br>
<br>
65535 will be more than you need, unless you plan to use thousands of parti=
tions or processes,<br>
which is a bad idea anyway.<br>
<br>
&gt; =C2=A0=C2=A0=C2=A02. What would be the recommended LimitNOFILE value f=
or PostgreSQL considering:multiple clusters<br>
&gt;=C2=A0 =C2=A0 =C2=A0 =C2=A0on same hostproduction workloadsPgBouncer us=
ageETL-heavy processing<br>
<br>
It all depends on how many files (tables, indexes) you plan to use.=C2=A0 I=
f you are worried,<br>
just set the limit higher.<br>
<br>
Yours,<br>
Laurenz Albe<br>
</blockquote></div>

--000000000000a39b4f0652b1e226--