Request a Demo
Home   >   mailing lists

Re: Request for Guidance on Recommended ulimit/Open File Settings for PostgreSQL 17 Multi-Cluster Environment - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Request for Guidance on Recommended ulimit/Open File Settings for PostgreSQL 17 Multi-Cluster Environment
Date
Msg-id bf0d57fcfe07c19c204e6b117c489414aa3514ba.camel@cybertec.at
Whole thread
In response to Request for Guidance on Recommended ulimit/Open File Settings for PostgreSQL 17 Multi-Cluster Environment  (mahamood hussain <hussain.ieg@gmail.com>)
Responses Re: Request for Guidance on Recommended ulimit/Open File Settings for PostgreSQL 17 Multi-Cluster Environment
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: mahamood hussain
Date:
Subject: Request for Guidance on Recommended ulimit/Open File Settings for PostgreSQL 17 Multi-Cluster Environment
Next
From: mahamood hussain
Date:
Subject: Re: Request for Guidance on Recommended ulimit/Open File Settings for PostgreSQL 17 Multi-Cluster Environment