Connections dropping while using Postgres backend DB with Ejabberd
I was trying to use postgresql database as a backend with
Ejabberd XMPP server for load test (Using TSUNG).
Noticed, while using Mnesia the “simultaneous users and open TCP/UDP connections” graph in Tsung report is showing consistency,
but while using Postgres, we see drop in connections during 100 to 500 seconds
of runtime, and then recovering and staying consistent.
I have been trying to figure out what the issue could be
without any success. I am kind of a noob in this technology, and hoping for
some help from the good people from the community to understand the problem and
how to fix this. Below are some details..
·Postgres server utilization is low ( Avg load 1,
Highest Cpu utilization 26%, lowest freemem 9000)