Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wRmfO-002hAo-3D for pgsql-admin@arkaria.postgresql.org; Tue, 26 May 2026 07:57:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wRmfK-003nFs-28 for pgsql-admin@arkaria.postgresql.org; Tue, 26 May 2026 07:57:31 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wRmfK-003nFc-0y for pgsql-admin@lists.postgresql.org; Tue, 26 May 2026 07:57:31 +0000 Received: from mail-wm1-x333.google.com ([2a00:1450:4864:20::333]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wRmfJ-00000000p59-2FaF for pgsql-admin@lists.postgresql.org; Tue, 26 May 2026 07:57:30 +0000 Received: by mail-wm1-x333.google.com with SMTP id 5b1f17b1804b1-4904c1ce4c1so38191165e9.3 for ; Tue, 26 May 2026 00:57:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1779782248; x=1780387048; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=r6GNDtrcckaXiKpe9gYETe3qSHj1P8sgz6z20X5pidw=; b=lcqt8eT3YY40NayLqQo15/Pm/Kr0zgFoUU+6oAMn5ngmUMDKIuN966bNE8a6LNHChy qjxy6Mh+C1T+KpVzjLF4JZ9b4ZuDZEfogJN80Hgvb2Xanzf3yB/t9lY+H9EYL+/HuogX N8oiXkjLbJekY2BLw0Am2Wmmr2gqeIKXI8khj4EiSibVYKUYNVI/fAmunndYakQFgHXY qXlAH1SgG+WTzN/xuRQnIX7SQui8qssfkM6B31QAaGTdvEqvDl8Ikwflznw/q9xqwti0 d4nd9283G8PM+O4MLz+H8up80F94RjWIcbMLJgdl6iNlWz2izHmDRDAW/P2sh0yoU9LX 8CQg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779782248; x=1780387048; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=r6GNDtrcckaXiKpe9gYETe3qSHj1P8sgz6z20X5pidw=; b=fX9vVGEWi9ZaCo7JMOZu8jdJIGfCeiAUn68yjmD+D1icuZgzVTBZ9sdVzDGigzQxkI w+qBt13/ay/tLANF3POs0wC/SE/p4qO5A2EOP9PCjsLVNTeGagQXY03XKem7u1bTN1YY E56x/ZTWfnyRcBKrlsyC7AzmzzDADtGSMDxpdhcFwt9XAJZxrcDA9A6jo3+2hnG9VJ6w VWfYevIf+1mBs/SWi0TDiFOXjoxvHeVs7TEqfROaja+G/XURoTHvVk9ANO7VPq0YNvi9 cDnwaFAjdwWozZhC4Xv9Klz6sK+0S2nNhDokJQjKDO4I9giYhr6ziCfnDIo2JbsVBnn6 SREA== X-Forwarded-Encrypted: i=1; AFNElJ9wNrV4ulsjE0l0fmRX6eAW5p6b52LdEHjUJ0PSP+EXvBooayRtRMFW9PFkFhqRlM7sAKNcVdClM5F0Cw==@lists.postgresql.org X-Gm-Message-State: AOJu0YxmKfFoL8aiiVAt0NrQ2ZL6zcgEtflxLMJ8KVP2EAJ9H+Gvzp4R tybSTtjxaze1vHPQ1TvlqVwBBzr89GCJxdEMXwgQLWIuOBit1Ou19L+lzms5nY3T0UM= X-Gm-Gg: Acq92OEuw5rOXMXzVJsHZp+d9qgHK4Cq76+NQ2zu3JhNrNFEv30bv+V0A9WDHXtSmCP xKURphPFonoLtLEEX2u3tMDqRbIvIkbB5Gug8I3tvq3JWHSA9SG7J6XtLHm6FR97L5O8rYDOsOL iRK+NGxw8DqgzzzIMWk8Kq5viw2rU9xZAulH2F+ew8wH19TfNxNPkQMPvUZ+3QDK8r43Q1mKkT8 54ocXXrB7e4L+AfnKwCDg4GBO/G39ujCFsJ6lhLCa2rjs4E9sjq2uF/oaPFqjKEsgRDRDfsFsJr OvUESAiWfz+76GVBo/C6a0eQlS/NA6Nnb71q0/S/29VU2NxMUyZ8qi5Y/fYQdHItaJRZry+DCCo i0jGu3RTSVFFEId0WI9W3n5nFr+MyJvexTvm5axqreziUr64OiscFSSG1BVu8218nVW8xyuEf3W RKW43VzUR1ZibtkBs9ffXSn3paHFUdBQpiCdJOCKY5X8IyflXxBety X-Received: by 2002:a05:600c:a106:b0:48a:9562:7a30 with SMTP id 5b1f17b1804b1-490426dcb09mr193597575e9.24.1779782247909; Tue, 26 May 2026 00:57:27 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:70:b5c9:3f80:6301:1948:db33]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-490452580dfsm158854305e9.1.2026.05.26.00.57.27 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 26 May 2026 00:57:27 -0700 (PDT) Message-ID: Subject: Re: Request for Guidance on Recommended ulimit/Open File Settings for PostgreSQL 17 Multi-Cluster Environment From: Laurenz Albe To: mahamood hussain , Pgsql-admin Date: Tue, 26 May 2026 09:57:26 +0200 In-Reply-To: References: 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 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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=E2=80=99m 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