Re: postgresql 7.1 file descriptor

From: mlw <markw(at)mohawksoft(dot)com>
To: jade <jade(at)vanzoest(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: postgresql 7.1 file descriptor
Date: 2002-05-08 16:00:18
Message-ID: 3CD94B92.F44A8983@mohawksoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2002-05-08 16:10:44 Re: Path to PostgreSQL portabiliy
Previous Message mlw 2002-05-08 15:58:34 Re: Path to PostgreSQL portabiliy

Browse pgsql-sql by date

  From Date Subject
Next Message Jean-Luc Lachance 2002-05-08 16:15:56 Performance on update from join
Previous Message Josh Berkus 2002-05-08 15:23:32 Re: psql: question