Re: PostgreSQL running out of file handles

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Alvaro Herrera <alvherre(at)surnet(dot)cl>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PostgreSQL running out of file handles
Date: 2005-05-13 03:16:35
Message-ID: 42841C13.6050003@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>>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?

7.4.6

Chris

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2005-05-13 03:16:46 Re: libpq lo_open errors when first action in connection
Previous Message Alvaro Herrera 2005-05-13 03:09:53 Re: PostgreSQL running out of file handles