| From: | Alvaro Herrera <alvherre(at)surnet(dot)cl> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL running out of file handles |
| Date: | 2005-05-13 03:09:53 |
| Message-ID: | 20050513030953.GA28148@surnet.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2005-05-13 03:16:35 | Re: PostgreSQL running out of file handles |
| Previous Message | Greg Sabino Mullane | 2005-05-13 02:39:25 | libpq lo_open errors when first action in connection |