From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
---|---|
To: | "Thomas F(dot) O'Connell" <tfo(at)monsterlabs(dot)com> |
Subject: | Re: large number of files open... |
Date: | 2002-01-16 22:09:59 |
Message-ID: | 3C45FA37.70708@selectacast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
If this is a linux system
echo 16384 > /proc/sys/fs/file-max
Thomas F. O'Connell wrote:
> 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
>
--
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio. http://xis.xtenit.com
From | Date | Subject | |
---|---|---|---|
Next Message | Darren Ferguson | 2002-01-16 23:56:40 | VARCHAR to INTEGER conversion |
Previous Message | Steve Wolfe | 2002-01-16 22:05:30 | Re: large number of files open... |