Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> writes: > Would it be worth for walwriter to grab a dozen of dummy fd's? I don't think so. As you point out, we could never positively guarantee no ENFILE failures anyway. If we were in an out-of-FDs situation, any such cushion would get whittled down to nothing pretty quickly, too. I've always thought that the fd.c layer is more about not having to configure the code explicitly for max-files-per-process limits. Once you get into ENFILE conditions, even if Postgres manages to stay up, everything else on the box is going to start falling over. So the sysadmin is likely to have to resort to a reboot anyway. (Hm, I wonder if that sort of thing explains the complaints we occasionally get about systems becoming completely nonresponsive under load? I'll bet you can't ssh into a machine that's up against the ENFILE limit, for instance.) 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
