From: jade <jade@vanzoest.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Cc: pgsql-hackers@postgresql.org
Subject: Re: [SQL] postgresql 7.1 file descriptor
Date: Wed, 8 May 2002 23:18:17 -0700 (PDT)
Message-ID: <20020508230403.H81883-100000@vision.estjohn.com> (raw)
In-Reply-To: <2952.1020875506@sss.pgh.pa.us>
On Wed, 8 May 2002, Tom Lane wrote:
> jade <jade@vanzoest.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jade@vanzoest.com, tgl@sss.pgh.pa.us, pgsql-hackers@postgresql.org
Subject: Re: [SQL] postgresql 7.1 file descriptor
In-Reply-To: <20020508230403.H81883-100000@vision.estjohn.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox