You should be using a connection pool, if you don't have the memory to support 800 connections then it just isn't going to work.
Dave
On 27-Nov-06, at 10:19 AM, Sistemasvi wrote:
Hello.
I have a postsgresql database with max 500 connections. All development is in Java (View, Model, controller model). The problem is when I have high traffic (about 10 AM) when the database server collapse. The server turn too slow as It haven´t memory and the swap memory increase too much. I must kill all postgres connections and restart postmaster service.
I have only one connection by web session. It is good or bad?
I have already increased the number of connections to 800 in the postgres and sysctl configuration file.
My server is linux Red Hat and Postgres database V8
