Too many open files! how do I fix on linux?

Started by adbabout 25 years ago4 messagesgeneral
Jump to latest
#1adb
adb@Beast.COM

Hi again, I'm getting stuff like

ERROR: cannot write block 1056 of tradehistory [testdb] blind: Too many
open files in system

and

postmaster: StreamConnection: accept: Too many open files in system

I understand that I need to up the max number of open files in the linux
kernel but I'd like to know what's a good number to set it to for a high
traffic postgres server and what's the best way to set it in linux so
it's permanent?

(These are during some performance tests I'm running with about 40
simultaneous clients)

Thanks,

Alex.

#2Alex Pilosov
alex@pilosoft.com
In reply to: adb (#1)
Re: Too many open files! how do I fix on linux?

On Fri, 26 Jan 2001, adb wrote:

I understand that I need to up the max number of open files in the linux
kernel but I'd like to know what's a good number to set it to for a high
traffic postgres server and what's the best way to set it in linux so
it's permanent?

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)

Show quoted text

(These are during some performance tests I'm running with about 40
simultaneous clients)

#3Tim Barnard
tbarnard@povn.com
In reply to: Alex Pilosov (#2)
Re: Too many open files! how do I fix on linux?

<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)

<snip>

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

Tim

#4Martin Tomes
martin.tomes@controls.eurotherm.co.uk
In reply to: Alex Pilosov (#2)
Re: Too many open files! how do I fix on linux?

"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