|
From what I've read briefly, not setting max_files_per_process will default it to 1000. This is when Postgres will clean up files, otherwise, it relies on the OS. One person set it lower, to 200, and was able to reduce an issue where they were seeing too many files open errors. Maybe in your case, Postgres doesn't need to have a lot of files open but isn't cleaning up after itself. Reducing max_files_per_process could help.
Do you have a test system for this? If not, can you get one? Personally, I hate not having a system where I can test out changes to see what happens, even if that system is one of my servers at home.
And by trade, I'm a DBA, mainly with Oracle, but have supported others, including Postgres, though I'm still picking up the intricacies there.
|