X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 5886C9FB2A3 for ; Tue, 12 Sep 2006 16:44:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 17250-02-6 for ; Tue, 12 Sep 2006 16:43:47 -0300 (ADT) X-Greylist: delayed 00:05:00.864112 by SQLgrey- Received: from mout.perfora.net (mout.perfora.net [217.160.230.40]) by postgresql.org (Postfix) with ESMTP id 8746A9FB393 for ; Tue, 12 Sep 2006 16:38:10 -0300 (ADT) Received: from [172.19.56.75] (helo=pustefix133.perfora.net) by mrelay.perfora.net (node=mrelayus1) with ESMTP (Nemesis), id 0MKp2t-1GNE0K2mA9-0001r1; Tue, 12 Sep 2006 15:33:08 -0400 Message-Id: <4307021.595181158089587924.JavaMail.servlet@perfora> From: jallgood@the-allgoods.net To: Subject: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Priority: 3 X-Binford: 6100 (more power) X-Mailer: Webmail X-Originating-From: 32485842 X-Routing: US X-Message-Id: <32485842$1158089587923172.19.56.7525800016@pustefix133.perfora.net-293865042> X-Received: from pustefix133.perfora.net by 198.212.166.61 with HTTP id 32485842 for [pgsql-performance@postgresql.org]; Tue, 12 Sep 2006 15:33:07 EDT Date: Tue, 12 Sep 2006 15:33:08 -0400 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.776 tagged_above=0 required=5 tests=MISSING_SUBJECT, NO_REAL_NAME, SPF_HELO_PASS X-Spam-Level: ** X-Archive-Number: 200609/100 X-Sequence-Number: 20786 Hello All I am getting this message in my log files for my database. LOG: out of file descriptors: Too many open files; release and retry. At some point the memomy didn't get released and the postmaster reset itself terminating all client connections. I am not sure what direction to go. I can increase the file-max in the kernel but it looks reasonably sized already . Or decrease the max_file_per_process. Has anyone on the list encountered this issue. I am running Postgres 7.4.7. Thanks John Allgood