Re: [HACKERS] PostgreSQL running out of file handles

2005-05-15 Thread Christopher Kings-Lynne
I suppose you are running on some BSD variant? BSD is notorious for promising more than it can deliver with respect to number of open files per process. This is a kernel bug, not a Postgres bug. You can adjust Postgres' max_files_per_process setting to compensate for the kernel's lying about its

[HACKERS] PostgreSQL running out of file handles

2005-05-12 Thread Christopher Kings-Lynne
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

Re: [HACKERS] PostgreSQL running out of file handles

2005-05-12 Thread Christopher Kings-Lynne
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

Re: [HACKERS] PostgreSQL running out of file handles

2005-05-12 Thread Tom Lane
Christopher Kings-Lynne [EMAIL PROTECTED] writes: 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

Re: [HACKERS] PostgreSQL running out of file handles

2005-05-12 Thread Alvaro Herrera
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

Re: [HACKERS] PostgreSQL running out of file handles

2005-05-12 Thread Christopher Kings-Lynne
I suppose you are running on some BSD variant? BSD is notorious for promising more than it can deliver with respect to number of open files per process. This is a kernel bug, not a Postgres bug. Good guess. Freebsd 4.8 or so. Chris ---(end of