Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 5AE9A4758F3 for ; Thu, 9 May 2002 02:18:19 -0400 (EDT) Received: from vision.estjohn.com (cts21612066130.cts.com [216.120.66.130]) by postgresql.org (Postfix) with SMTP id 72FE647585D for ; Thu, 9 May 2002 02:18:17 -0400 (EDT) Received: (qmail 84511 invoked by uid 2001); 9 May 2002 06:18:17 -0000 Received: from localhost (sendmail-bs@127.0.0.1) by localhost with SMTP; 9 May 2002 06:18:17 -0000 Date: Wed, 8 May 2002 23:18:17 -0700 (PDT) From: jade X-X-Sender: To: Tom Lane Cc: , Subject: Re: [SQL] postgresql 7.1 file descriptor In-Reply-To: <2952.1020875506@sss.pgh.pa.us> Message-ID: <20020508230403.H81883-100000@vision.estjohn.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200205/411 X-Sequence-Number: 22618 On Wed, 8 May 2002, Tom Lane wrote: > jade writes: > > I am running postgresql - 7.1 on Redhat 2.2.16-22 kernel. > > Sometimes this the system becomes totally unusable with > > "VFS: file-max limit 4096 reached" error? The system is setup to have > > 4096 file descriptor as default. I was wondering how many file descriptor > > does postgres open per backend process? > > Potentially lots. Increase your system's NFILE limit, or reduce the max > number of backends you will allow PG to start, or update to 7.2 which > will let you set a per-backend file limit (see MAX_FILES_PER_PROCESS; > AFAIR that parameter did not exist in 7.1). Hi All, Thanks for all the response -- it was all very helpful! I don't want to limit the my backend processes because each response is consider "important" so running any backend limitation is consider unaccceptable. So, I've increased the system NFIle limit.. so far so good :-) Are they any way to pool connections through a single backend process? thanks, Thanh