large number of files open...
Thomas F.O'Connell <tfo@monsterlabs.com>
From: "Thomas F. O'Connell" <tfo@monsterlabs.com>
To: pgsql-general@postgresql.org
Date: 2002-01-16T20:53:27Z
Lists: pgsql-general
i'm running postgres 7.1.3 in a production environment. the database itself contains on the order of 100 tables, including some complex triggers, functions, and views. a few tables (on the order of 10) that are frequently accessed have on the order of 100,000 rows. every now and then, traffic on the server, which is accessed publicly via mod_perl (Apache::DBI) causes the machine itself to hit the kernel hard limit of number of files open: 8191. this, unfortunately, crashes the machine. in a production environment of this magnitude, is that a reasonable number of files to expect postgres to need at any given time? is there any documentation anywhere on what the number of open files depends on? -tfo