public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: 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: Mon, 25 May 2026 23:03:09 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAGc_7H=OAK6sf0EEMv-_9fcAM76UFT=BzzfWs-sTSjsFj43vEA@mail.gmail.com>
References: <CAGc_7H=OAK6sf0EEMv-_9fcAM76UFT=BzzfWs-sTSjsFj43vEA@mail.gmail.com>

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], [email protected]
  Subject: Re: Request for Guidance on Recommended ulimit/Open File Settings for PostgreSQL 17 Multi-Cluster Environment
  In-Reply-To: <[email protected]>

* 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