| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| 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:31:46 |
| Message-ID: | 2952.1020875506@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-sql |
jade <jade(at)vanzoest(dot)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).
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2002-05-08 16:41:18 | Re: Path to PostgreSQL portabiliy |
| Previous Message | mlw | 2002-05-08 16:29:07 | Re: Path to PostgreSQL portabiliy |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Masaru Sugawara | 2002-05-08 16:51:59 | Re: blanking out repeated columns in rows |
| Previous Message | Jean-Luc Lachance | 2002-05-08 16:15:56 | Performance on update from join |