Re: Errors: Too many open files

Tom Lane wrote:
> Ken <mailinglists(at)creason(dot)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 ...

It is the right place. IIRC the default is either 4 or 8K. I
usually set it to 32K or even more (depends on the number of
tables and number of backends I expect).

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com