PostgreSQL running out of file handles

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: PostgreSQL running out of file handles
Date: 2005-05-13 01:45:15
Message-ID: 428406AB.4070408@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

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?

Chris

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2005-05-13 01:51:57 Re: Views, views, views: Summary of Arguments
Previous Message David Fetter 2005-05-12 23:59:07 Re: Views, views, views: Summary of Arguments