public inbox for [email protected]  

help / color / mirror / Atom feed

From: mahamood hussain <[email protected]>
To: Pgsql-admin <[email protected]>
Subject: Re: Request for Guidance on Recommended ulimit/Open File Settings for PostgreSQL 17 Multi-Cluster Environment
Date: Tue, 26 May 2026 11:06:53 +0530
Message-ID: <CAGc_7H=fZo7TV+uJApkwuMv1+zbTOS+wodZxzTR6YbpH2O-GZQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAGc_7H=OAK6sf0EEMv-_9fcAM76UFT=BzzfWs-sTSjsFj43vEA@mail.gmail.com>
	<[email protected]>

Thank you for your response.

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

On Tue, May 26, 2026 at 2:33 AM Laurenz Albe <[email protected]>
wrote:

> On Mon, 2026-05-25 at 22:46 +0530, mahamood hussain wrote:
> > Current DB2 Setting:
> > Max open files = 65535
> > We would like clarification on:
> >    1. Is increasing the open file limit (ulimit -n) recommended/required
> 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 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
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Request for Guidance on Recommended ulimit/Open File Settings for PostgreSQL 17 Multi-Cluster Environment
  In-Reply-To: <CAGc_7H=fZo7TV+uJApkwuMv1+zbTOS+wodZxzTR6YbpH2O-GZQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox