Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 9EFD19FA1A7 for ; Thu, 30 Nov 2006 10:52:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 11988-10 for ; Thu, 30 Nov 2006 10:52:03 -0400 (AST) X-Greylist: delayed 00:25:11.131022 by SQLgrey-1.7.4 Received: from www.3times25.net (66-23-211-34.clients.speedfactory.net [66.23.211.34]) by postgresql.org (Postfix) with ESMTP id E61A89FA18B for ; Thu, 30 Nov 2006 10:52:08 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by www.3times25.net (Postfix) with ESMTP id 032C654020; Thu, 30 Nov 2006 09:26:52 -0500 (EST) Message-ID: <456EEA2C.6070901@3times25.net> Date: Thu, 30 Nov 2006 09:26:52 -0500 From: Geoffrey User-Agent: Thunderbird 1.5.0.8 (X11/20061025) MIME-Version: 1.0 To: Bradley Kieser CC: John Allgood , pgsql-admin@postgresql.org, Terry Lee Tucker , "J. D. Pearson" 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> <456EE6CE.2030106@3times25.net> <456EE935.6080705@kieser.net> In-Reply-To: <456EE935.6080705@kieser.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/254 X-Sequence-Number: 23781 Bradley Kieser wrote: > Hmm, not entirely true. You may well only see the error in the process > itself. You're telling me that the kernel could be running out of file descriptors and I wouldn't see a message regarding this in the kernel logs? I don't believe that is possible. > > > Geoffrey wrote: >> 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 work with the original poster and wanted to make sure the problem >> here is clear. The 'out of file descriptors' message is coming from >> Postgresql, not the kernel. Thus, it doesn't make sense to me that >> the max_files_per_process setting is too high. I would think we need >> to increase it so that Postgresql will stop generating these errors. >> > -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin