The version data below belongs to the server which runs the RHQ server and the RHQ database.
I understand it's easy to reach the 10K open files, I can also accept if it is normal, but what are the recommended settings then? Other Pg servers which don't run the RHQ server works for a long time with higher "active backend" amount and much smaller "open files" amount!
root@ct-front:/etc/postgresql/9.2/main# ulimit -n 1024
Attila
2013/9/24 Attila Heidrich attila.heidrich@gmail.com
OS is Debian Wheezy (64bit) Pg: 9.2.4-1.pgdg70+1 RHQ is 4.9
Other hosts running the very same versions, the agent-only configs have no problem at all (only the agents' problem with Pg 9.2). There are also other Linux versions and a few Windows config (XP and 2008 server), most of the platform runs Pg as well.
Attila