Message-ID: <bf0d57fcfe07c19c204e6b117c489414aa3514ba.camel@cybertec.at>
Subject: Re: Request for Guidance on Recommended ulimit/Open File Settings
 for PostgreSQL 17 Multi-Cluster Environment
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: mahamood hussain <hussain.ieg@gmail.com>, Pgsql-admin
	 <pgsql-admin@lists.postgresql.org>
Date: Mon, 25 May 2026 23:03:09 +0200
In-Reply-To: 
 <CAGc_7H=OAK6sf0EEMv-_9fcAM76UFT=BzzfWs-sTSjsFj43vEA@mail.gmail.com>
References: 
	<CAGc_7H=OAK6sf0EEMv-_9fcAM76UFT=BzzfWs-sTSjsFj43vEA@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/bf0d57fcfe07c19c204e6b117c489414aa3514ba.camel%40cybertec.at>
Precedence: bulk

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:
> =C2=A0=C2=A0=C2=A01. Is increasing the open file limit (ulimit -n) recomm=
ended/required for PostgreSQL in such
>       multi-cluster production environments?

65535 will be more than you need, unless you plan to use thousands of parti=
tions or processes,
which is a bad idea anyway.

> =C2=A0=C2=A0=C2=A02. What would be the recommended LimitNOFILE value for =
PostgreSQL considering:multiple clusters
>       on same hostproduction workloadsPgBouncer usageETL-heavy processing

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