public inbox for [email protected]  

help / color / mirror / Atom feed

From: Durgamahesh Manne <[email protected]>
To: Sri Mrudula Attili <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: PostgreSQL mailing lists <[email protected]>
Subject: Re: Postgresql database terminates abruptly with too many open files error
Date: Sun, 19 Jan 2025 14:31:18 +0530
Message-ID: <CAJCZkoLT_9iL+C9iMP+C6-7Fha0uy4UN5c6vNZPRoKs-+G8viQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

---------- Forwarded message ---------
From: Sri Mrudula Attili <[email protected]>
Date: Wed, 15 Jan, 2025, 17:12
Subject: Re: Postgresql database terminates abruptly with too many open
files error
To: Tom Lane <[email protected]>
Cc: <[email protected]>


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 <[email protected]> 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

view thread (6+ messages)  latest in thread

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: Postgresql database terminates abruptly with too many open files error
  In-Reply-To: <CAJCZkoLT_9iL+C9iMP+C6-7Fha0uy4UN5c6vNZPRoKs-+G8viQ@mail.gmail.com>

* 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