Postgres Server collapse

From: "Sistemasvi" <sistemasvi(at)aerogal(dot)com(dot)ec>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Postgres Server collapse
Date: 2006-11-27 15:19:49
Message-ID: 002401c71237$92e23cf0$9f0a0a0a@aerogald.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Which can be the problem?.

Carlos

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message John S.Abraham 2006-11-27 15:22:02 Re: Backup with Java
Previous Message tommaso.taruffi@ricesoft.it 2006-11-27 15:00:10 Backup with Java