Andres Freund <andres@xxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
