Re: Bottlenecks with large number of relation segment files

Andres Freund <andres@2ndquadrant.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