Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 2B41B476BB1; Wed, 8 May 2002 13:28:36 -0400 (EDT) Received: from snoopy.mohawksoft.com (h0050bf7a618d.ne.client2.attbi.com [24.147.138.78]) by postgresql.org (Postfix) with ESMTP id 7E146476837; Wed, 8 May 2002 12:05:35 -0400 (EDT) Received: from mohawksoft.com (localhost [127.0.0.1]) by snoopy.mohawksoft.com (8.11.6/8.11.6) with ESMTP id g48G0It23044; Wed, 8 May 2002 12:00:18 -0400 Message-ID: <3CD94B92.F44A8983@mohawksoft.com> Date: Wed, 08 May 2002 12:00:18 -0400 From: mlw X-Mailer: Mozilla 4.78 [en] (X11; U; Linux 2.4.18-SMP-020426 i686) X-Accept-Language: en MIME-Version: 1.0 To: jade Cc: pgsql-sql@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: postgresql 7.1 file descriptor References: <20020507152551.M65365-100000@vision.estjohn.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200205/359 X-Sequence-Number: 22566 jade wrote: > > Hi, > > 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? One for each file in your database, one for the communication's socket, etc. Your best bet is to add more files.