Re: Postgres Server collapse - Mailing list pgsql-jdbc

From Csaba Nagy
Subject Re: Postgres Server collapse
Date
Msg-id 1164641886.13204.111.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Postgres Server collapse  ("Sistemasvi" <sistemasvi@aerogal.com.ec>)
List pgsql-jdbc
[snip]
> 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.

You should probably google for "connection pool" in general to see what
that means, and pick a solution for JDBC. 800 connections is way too
much, we have here ~100 in real use at any time for a busy (read: with
many users and web sessions) application.

Cheers,
Csaba.



pgsql-jdbc by date:

Previous
From: Mark Lewis
Date:
Subject: Re: Postgres Server collapse
Next
From: Markus Schaber
Date:
Subject: Re: Backup with Java