Re: PostgreSQL running out of file handles - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: PostgreSQL running out of file handles
Date
Msg-id 20050513030953.GA28148@surnet.cl
Whole thread Raw
In response to PostgreSQL running out of file handles  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: PostgreSQL running out of file handles  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
On Fri, May 13, 2005 at 09:45:15AM +0800, Christopher Kings-Lynne wrote:

> A few days back the load increased on our database server to the point 
> where it could not get enough file handles.  This causes the backends to 
> crash, get restarted only to crash again, on and on.
> 
> We fixed it by bumping kern.maxfiles, but was just wondering if this is 
> a scenario that PostgreSQL should handle more gracefully?

We certainly go great lengths to prevent this problem ... what version
is this?

-- 
Alvaro Herrera (<alvherre[a]surnet.cl>)
"The important things in the world are problems with society that we don't
understand at all. The machines will become more complicated but they won't
be more complicated than the societies that run them."    (Freeman Dyson)


pgsql-hackers by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: libpq lo_open errors when first action in connection
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: PostgreSQL running out of file handles