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

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: mahamood hussain <hussain(dot)ieg(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Request for Guidance on Recommended ulimit/Open File Settings for PostgreSQL 17 Multi-Cluster Environment
Date: 2026-05-26 07:57:26
Message-ID: c0f34f4cf8d9c55ebae086fbfb0be05143be6d50.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, 2026-05-26 at 11:06 +0530, mahamood hussain wrote:
> How can I determine whether the current setting is sufficient and verify
> that I’m not hitting any limits with the existing value?

By watching out for nasty errors from your SQL statements...

Why don't you set the limit to "unlimited" and stop worrying?

Yours,
Laurenz Albe

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message shammat 2026-05-30 19:41:56 Collation changes
Previous Message mahamood hussain 2026-05-26 05:36:53 Re: Request for Guidance on Recommended ulimit/Open File Settings for PostgreSQL 17 Multi-Cluster Environment