Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 065999FA0CC for ; Thu, 30 Nov 2006 09:23:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 20998-02 for ; Thu, 30 Nov 2006 09:23:48 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from Mercury.turbocorp.com (mercury.turbocorp.com [198.212.166.40]) by postgresql.org (Postfix) with ESMTP id 0241E9F9C9E for ; Thu, 30 Nov 2006 09:23:47 -0400 (AST) Received: from [198.212.166.61] (Voyager.turbocorp.com [198.212.166.61]) by Mercury.turbocorp.com (8.13.1/8.13.1) with ESMTP id kAUDHi9R020554 for ; Thu, 30 Nov 2006 08:17:44 -0500 Message-ID: <456EDB62.9020009@the-allgoods.net> Date: Thu, 30 Nov 2006 08:23:46 -0500 From: John Allgood User-Agent: Thunderbird 1.5.0.8 (X11/20060911) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Out of file-descriptors message References: <456DF2DE.3060002@turbocorp.com> <4727.1164835974@sss.pgh.pa.us> <456E03C9.6070204@the-allgoods.net> <20061129222523.GI7001@alvh.no-ip.org> In-Reply-To: <20061129222523.GI7001@alvh.no-ip.org> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/249 X-Sequence-Number: 23776 Alvaro Herrera wrote: > John Allgood wrote: > >> Hey Tom >> >> I assume that if it is the kernel running out of descriptors that I >> would get the messages in dmesg. This message only appears in the log >> file for that database. >> > > Yeah, the point is that you have the max_files_per_process setting > higher than what the kernel likes. So decrease it, and Postgres will > adjust itself to use less file descriptors by closing and reopening > files as needed. > > I really can't see that is possible file-max is set to 838860. I believe it is based on the amount of ram on the machine and we have 8GB. ulimit -a reports you can have 1024 open files. I thought maybe we were running out of descriptors for the postgres user but that should not bring down the machine. Thoughts anyone.