I have this notorious problem: at some point pgsql simply hangs up and requires a restart.
May we see the content of pg_stat_activity and the content of pg_locks ?
I realize my app is very resource hungry but the thing is that it works great with mysql. The problem occurs only with pgsql which i realy need.
You need pgsql or mysql was not enough ? Please no flames here.
Regards Gaetano Mendola
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
