MIME-Version: 1.0
References: <0af98214-3c2a-43e5-9bbf-ddd79b85ea93@ebi.ac.uk>
 <709d5fa0-85e1-40a2-a6a4-11040f4e5b62@ebi.ac.uk> <679341.1736864393@sss.pgh.pa.us>
 <9b69fcc6-dca1-4671-af00-b250f154fb14@ebi.ac.uk>
In-Reply-To: <9b69fcc6-dca1-4671-af00-b250f154fb14@ebi.ac.uk>
From: Durgamahesh Manne <maheshpostgres9@gmail.com>
Date: Sun, 19 Jan 2025 14:31:18 +0530
Message-ID: <CAJCZkoLT_9iL+C9iMP+C6-7Fha0uy4UN5c6vNZPRoKs-+G8viQ@mail.gmail.com>
Subject: Re: Postgresql database terminates abruptly with too many open files error
To: Sri Mrudula Attili <sri@ebi.ac.uk>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, 
	PostgreSQL mailing lists <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ccaea1062c0b63e6"
Archived-At: <https://www.postgresql.org/message-id/CAJCZkoLT_9iL%2BC9iMP%2BC6-7Fha0uy4UN5c6vNZPRoKs-%2BG8viQ%40mail.gmail.com>
Precedence: bulk

--000000000000ccaea1062c0b63e6
Content-Type: text/plain; charset="UTF-8"

---------- Forwarded message ---------
From: Sri Mrudula Attili <sri@ebi.ac.uk>
Date: Wed, 15 Jan, 2025, 17:12
Subject: Re: Postgresql database terminates abruptly with too many open
files error
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: <pgsql-general@postgresql.org>


Hello Tom,


The max_connections =200 and max_files_per_process =1000 as you mentioned.

So should a max_files_per_process =500 helps?


I could see from the number of connections to the databaseis not
exceeding 20. But still these 20 are causing all the damage or using up
all the openfiles quota.


Thanks,

Sri

On 14/01/2025 14:19, Tom Lane wrote:
> Sri Mrudula Attili <sri@ebi.ac.uk> writes:
>>    We have a postgresql VDB(virtual database- Delphix) that keeps
>> terminating due "to too many open files".
> What do you have max_connections set to, and how many actually-live
> server processes are there typically?
>
>> The number of allowed openfiles at OS level are 65000.
> I'm suspecting that you either need to increase that, decrease
> max_files_per_process (which defaults to 1000), or decrease
> max_connections.
>
>                       regards, tom lane


Hi Team,

What is the final conclusion for this ?

Regards,
Durga Mahesh

--000000000000ccaea1062c0b63e6
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><br><br><div class=3D"gmail_quote gmail_quote_container" =
dir=3D"auto"><div dir=3D"ltr" class=3D"gmail_attr">---------- Forwarded mes=
sage ---------<br>From: <strong class=3D"gmail_sendername" dir=3D"auto">Sri=
 Mrudula Attili</strong> <span dir=3D"auto">&lt;<a href=3D"mailto:sri@ebi.a=
c.uk">sri@ebi.ac.uk</a>&gt;</span><br>Date: Wed, 15 Jan, 2025, 17:12<br>Sub=
ject: Re: Postgresql database terminates abruptly with too many open files =
error<br>To: Tom Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.=
pa.us</a>&gt;<br>Cc:  &lt;<a href=3D"mailto:pgsql-general@postgresql.org">p=
gsql-general@postgresql.org</a>&gt;<br></div><br><br>Hello Tom,<br>
<br>
<br>
The max_connections =3D200 and max_files_per_process =3D1000 as you mention=
ed.<br>
<br>
So should a max_files_per_process =3D500 helps?<br>
<br>
<br>
I could see from the number of connections to the databaseis not <br>
exceeding 20. But still these 20 are causing all the damage or using up <br=
>
all the openfiles quota.<br>
<br>
<br>
Thanks,<br>
<br>
Sri<br>
<br>
On 14/01/2025 14:19, Tom Lane wrote:<br>
&gt; Sri Mrudula Attili &lt;<a href=3D"mailto:sri@ebi.ac.uk" target=3D"_bla=
nk" rel=3D"noreferrer">sri@ebi.ac.uk</a>&gt; writes:<br>
&gt;&gt;=C2=A0 =C2=A0=C2=A0We have a postgresql VDB(virtual database- Delph=
ix) that keeps<br>
&gt;&gt; terminating due &quot;to too many open files&quot;.<br>
&gt; What do you have max_connections set to, and how many actually-live<br=
>
&gt; server processes are there typically?<br>
&gt;<br>
&gt;&gt; The number of allowed openfiles at OS level are 65000.<br>
&gt; I&#39;m suspecting that you either need to increase that, decrease<br>
&gt; max_files_per_process (which defaults to 1000), or decrease<br>
&gt; max_connections.<br>
&gt;<br>
&gt;=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0regards, tom lane<br>
<br><br>Hi Team,</div><div class=3D"gmail_quote gmail_quote_container" dir=
=3D"auto"><br></div><div class=3D"gmail_quote gmail_quote_container" dir=3D=
"auto">What is the final conclusion for this ?</div><div class=3D"gmail_quo=
te gmail_quote_container" dir=3D"auto"><br></div><div class=3D"gmail_quote =
gmail_quote_container" dir=3D"auto">Regards,</div><div class=3D"gmail_quote=
 gmail_quote_container" dir=3D"auto">Durga Mahesh=C2=A0</div><div class=3D"=
gmail_quote gmail_quote_container" dir=3D"auto"><br></div><div class=3D"gma=
il_quote gmail_quote_container" dir=3D"auto">
<br>
</div></div>

--000000000000ccaea1062c0b63e6--