I am working with a postgres database on openbsd 4.2 -stable. I was wondering what the most correct method would be to monitor the number of open files? I assume (perhaps incorrectly) that the 'openfiles-cur=768' entry that I created for the postgres login class might be identifiable roughly with the command fstat -u _postgresql |wc -l . Is there any chance anyone can tell me if my assumptions are correct?
Thanks Roy