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

From: adb <adb(at)Beast(dot)COM>
To: pgsql-general(at)postgresql(dot)org
Subject: Too many open files! how do I fix on linux?
Date: 2001-01-27 03:23:51
Message-ID: Pine.GSO.4.10.10101261918090.2561-100000@hairdini.beast.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2001-01-27 03:26:35 Re:
Previous Message Doug McNaught 2001-01-27 03:22:40 Re: Backends dying due to memory exhaustion--I'm stonkered