Re: Too many open files! how do I fix on linux? - Mailing list pgsql-general

From Martin Tomes
Subject Re: Too many open files! how do I fix on linux?
Date
Msg-id uwvbeln95.fsf@martin.controls.eurotherm.co.uk
Whole thread Raw
In response to Re: Too many open files! how do I fix on linux?  (Alex Pilosov <alex@pilosoft.com>)
List pgsql-general
>>>>> "Tim" == Tim Barnard <tbarnard@povn.com> writes:

    Tim> <snip>
    >> I set to 16384. with about 100 clients this seems to be enough.  Best
    >> way to set it is in your local rc script (/etc/rc.d/rc3.d/*local)
    Tim> <snip>

    Tim> How do you go about doing this on a RedHat 6.2 system? There is an
    Tim> S99local file but nothing in it on setting maximum open files.

I had to do this last week.  On RedHat 6.2 put this at the end
of /etc/rc.d/rc.local:

echo 8192 > /proc/sys/fs/file-max
echo 32768 > /proc/sys/fs/inode-max

It increases file handles to 8192, you are supposed to have four times as many
inode handles as file handles so it increases those too.

--
Martin Tomes

Martin.Tomes@controls.eurotherm.co.uk

pgsql-general by date:

Previous
From: Alex Guryanow
Date:
Subject: Re[6]: SPI_getvalue problem
Next
From: Andy Corteen
Date:
Subject: Fwd: Re: Timeouts on connections