From: | Frank Finner <frank(at)finner(dot)de> |
---|---|
To: | Ken <mailinglists(at)creason(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Errors: Too many open files |
Date: | 2001-12-07 06:21:11 |
Message-ID: | XFMail.011207072111.frank@finner.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Ken,
we´ve had the same problem with a samba fileserver, which regularly
choked with a "too many open filehandles" message. We found out that
the value 8192 is nowadays the standard for /proc/sys/fs/file-max and
you can set it to much higher values. For example, the SuSE people say,
that for their Email-Server it should be set to 65536. There might also
be a value /proc/sys/fs/inode-max (may be only for certain file
systems), which according to SuSE might also be risen to 131072.
Maybe it helps.
mfg Frank Finner
On 07-Dec-01 Ken sat down, thought for a long time and then wrote:
> During busy hours, Postgres and Apache are reporting
> errors that there are too many open files, and sometimes
> Postgres will crash. I've searched all over for a way
> to increase this resource limit.
> I have tried:
>
> ulimit -n 8192
> (seems only to work for the current shell session)
>
> echo "8192" > /proc/sys/fs/file-max
> (did not seem to make a difference)
>
> adding this entry to /etc/security/limits.conf:
> postgres hard nofile 4096
> (did not seem to make a difference)
--
Frank Finner
And now there is no turning back at all.
(M. Moorcock, "Elric Of Melnibone")"
From | Date | Subject | |
---|---|---|---|
Next Message | Holger Krug | 2001-12-07 07:30:47 | Re: Using Cursor in PostgreSQL 7.2 |
Previous Message | Ken | 2001-12-07 04:10:18 | Re: Errors: Too many open files |