Hi,
Am 16.09.2013 um 15:07 schrieb Attila Heidrich:
since I use 4.9, the Pg under the RHQ consumes most of the
resources.
open files reached 20K during the weekend, which stopped the whole server working, and
also the used physical memory increasing monotonically. I have had to restart RHQ server
only, did not touch Pg.
That are 20k open files for the RHQ server or for Postgres?
If for postgres - can you determine the number of open connections?
If it is the server, can you run a lsof -p <pid of the server> to see what files
are open?
what should I do to prevent this? I have never suffered from this
with 4.8!
If I knew :-/ Are you using the postgres agent plugin?
Heiko