Alvaro Herrera <alvhe...@2ndquadrant.com> writes: > On 2020-Feb-24, Tom Lane wrote: >> Why not just drive it off max_files_per_process? On Unix, that >> largely exists to override the ulimit setting anyway. With no >> comparable knob on a Windows system, we might as well just say >> that's what you set.
> That makes sense to me -- but if we do that, then maybe we should be > doing the setrlimit() dance on it too, on Linux^W^W where supported. Yeah, arguably we could try to setrlimit if max_files_per_process is larger than the ulimit. We should definitely not reduce the ulimit if max_files_per_process is smaller, though, since the DBA might intentionally be leaving daylight for purposes such as FD-hungry PL functions. On the whole I'm inclined to leave well enough alone on the Unix side --- there's nothing there that the DBA can't set if she wishes. regards, tom lane