>> I am running of postgresql database servers with generally 30-50 users >> at a time per server. I have noticed one thing for web based databases >> that they fail to initialse a pg_connection connection every now and >> again and return no error message at all.
I am thinking of the PG_SOMAXCONN maximum connects in the queue of the listen socket. That would only be visible to the client app, and would mainly happen when load is high so that postmaster cannot fork new backends fast enough. And if the client does not properly report ... IIRC some systems have a max of 5. Andreas ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
