Re: Errors: Too many open files - Mailing list pgsql-general

From Ken
Subject Re: Errors: Too many open files
Date
Msg-id 5.0.2.1.0.20011207100718.01f1c1d0@mail.fcs.net
Whole thread Raw
In response to Re: Errors: Too many open files  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I believe the original value of /proc/sys/fs/file-max
was 1024, but I may very well be mistaken.
I have increased that value now to 65536 in hopes
that it makes the difference. Thank you Andrew, Frank
and Tom for your kind advice.
_Ken


At 07:29 AM 12/7/01, you wrote:
>Ken <mailinglists@creason.com> writes:
>> During busy hours, Postgres and Apache are reporting
>> errors that there are too many open files, and sometimes
>> Postgres will crash.
>
>You need to raise the kernel's file table size (most Unixen call
>this kernel parameter NFILE; also NINODE might be interesting).
>It's a system-wide limit, not a per-process limit.
>
>> echo "8192" > /proc/sys/fs/file-max
>> (did not seem to make a difference)
>
>This *looks* plausible, but I'm not familiar enough with Linux to know
>if that's the right incantation or not.  Also, did you check to see
>what the original value is?  I'm not sure that 8k is more than the
>default ...
>
>                        regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster


pgsql-general by date:

Previous
From: Dado Feigenblatt
Date:
Subject: Re: Where is PL/Python?
Next
From: Jan Wieck
Date:
Subject: Re: Trigger problem