What is recommended postgresql connection count for NGL?
This post was updated on .
I had a new NGL(3.1.2) server setup early this year on *inx system with postgresql 8.4.20
but lately NGL server had some issue in postgresql, postgres process consumed whole lot of memory for a certain amount of time. When there's memory usage spikes,
database server need be restarted and NGL server went back to normal.
During those memory usage spikes, users even cannot access to the NGL web front.
I am not sure it also has effect on tomcat.
Temporary Solution: Increase max_connection count from default "100" to "200"
Increase shared_buffer size from default "24" to "128" MB
Progress After Setting Update (10-May-2018)~(13-May-2018)
However I would like to request expertise advice on postgresql connection counts per user ratio so that I can properly do necessary adjustment.