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

Re: Postgres Server collapse

From: imad <immaad(at)gmail(dot)com>
To: Sistemasvi <sistemasvi(at)aerogal(dot)com(dot)ec>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Postgres Server collapse
Date: 2006-11-27 18:26:07
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
On 11/27/06, Sistemasvi <sistemasvi(at)aerogal(dot)com(dot)ec> 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?

One connection only? Then why did you increased the number of connections
to 800? Sorry, I might be missing some point here.

> 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


In response to


pgsql-jdbc by date

Next:From: Michael SchmidtDate: 2006-11-27 19:30:01
Subject: Re: Backup with Java
Previous:From: imadDate: 2006-11-27 18:20:17
Subject: Re: Backup with Java

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