| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Andres Freund <andres(at)2ndquadrant(dot)com> |
| Cc: | KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp>, Amit Langote <amitlangote09(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [GENERAL] Bottlenecks with large number of relation segment files |
| Date: | 2013-08-05 12:23:36 |
| Message-ID: | 8091.1375705416@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Andres Freund <andres(at)2ndquadrant(dot)com> writes:
> ... Also, there are global
> limits to the amount of filehandles that can simultaneously opened on a
> system.
Yeah. Raising max_files_per_process puts you at serious risk that
everything else on the box will start falling over for lack of available
FD slots. (PG itself tends to cope pretty well, since fd.c knows it can
drop some other open file when it gets EMFILE.) We more often have to
tell people to lower that limit than to raise it.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Travers | 2013-08-05 13:00:57 | Re: Why are stored procedures looked on so negatively? |
| Previous Message | Florian Weimer | 2013-08-05 11:38:41 | Re: Bottlenecks with large number of relation segment files |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2013-08-05 12:35:45 | Re: [v9.4] row level security |
| Previous Message | Tom Lane | 2013-08-05 12:18:33 | Re: Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review]) |