Re: postgresql 7.1 file descriptor - Mailing list pgsql-sql

From mlw
Subject Re: postgresql 7.1 file descriptor
Date
Msg-id 3CD94B92.F44A8983@mohawksoft.com
Whole thread Raw
In response to postgresql 7.1 file descriptor  (jade <jade@vanzoest.com>)
List pgsql-sql
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.


pgsql-sql by date:

Previous
From: Gabriel Dovalo Carril
Date:
Subject: Can this query be faster?
Next
From: Scott Marlowe
Date:
Subject: Re: [HACKERS] postgresql 7.1 file descriptor