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.
On 27-Nov-06, at 10:19 AM, Sistemasvi wrote:
> 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
> Which can be the problem?.
In response to
pgsql-jdbc by date
|Next:||From: Mark Lewis||Date: 2006-11-27 15:34:37|
|Subject: Re: Postgres Server collapse|
|Previous:||From: John S.Abraham||Date: 2006-11-27 15:22:02|
|Subject: Re: Backup with Java|