Re: postgresql 7.1 file descriptor

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.