Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #2782: Too Many open files in system - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2782: Too Many open files in system
Date
Msg-id 27634.1164682866@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2782: Too Many open files in system  ("Alaa El Gohary" <alaaelgohary@bftech.com.eg>)
List pgsql-bugs
Tree view 
"Alaa El Gohary" <alaaelgohary@bftech.com.eg> writes:
> this message appears when trying to open an application
> Fatal:could not open file"/usr/local/pgsql/data/global/1262":too many open
> files in system

Try reducing max_files_per_process.  Your kernel is evidently promising
more than it can deliver about how many files each process can open.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2784: Performance serious degrades over a period of a month
Next
From: Tom Lane
Date:
Subject: Re: BUG #2785: Exception Issue