Skip site navigation (1) Skip section navigation (2)

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$ (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc

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?.




pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group