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

From Jan Wieck
Subject Re: Errors: Too many open files
Date
Msg-id 200112071808.fB7I8gf02154@saturn.jw.home
Whole thread Raw
In response to Re: Errors: Too many open files  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane 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 ...

    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@Yahoo.com #



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


pgsql-general by date:

Previous
From: Ken
Date:
Subject: Re: Errors: Too many open files
Next
From: Andrew Gould
Date:
Subject: Re: When do I Vacuum ?