G'day all,
We recently had a bit of a catastrophe when one of our postgres databases opened too many files. It was a reasonably easy fix, but it did get me thinking. Is there a rule of thumb in determining how many file descriptors should be available to a postgres database/cluster?
I'd be happy to set it to some large number, but I'd really like some confidence about how much the database can grow with a new limit.
Cheers!
--Royce