BUG #5995: connection pooling not working

From: "Suprabhat" <suprabhatm(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5995: connection pooling not working
Date: 2011-04-27 11:55:13
Message-ID: 201104271155.p3RBtDwu092291@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-bugs


The following bug has been logged online:

Bug reference: 5995
Logged by: Suprabhat
Email address: suprabhatm(at)gmail(dot)com
PostgreSQL version: 8.4
Operating system: ubuntu
Description: connection pooling not working
Details:

Hi, we are using java jsp front end to develop a web based application which
runs fine using odbc:jdbc link for mssql. The moment we switched over to
using postgresql, it kept on telling FATAL: too many connections already and
there are too many postgres processes on the server. We have used connection
pooling methods after unsuccessfully using pgpool2. I am really wondering
how the big companies are using this database without any issues. Probably
we are doing some basics wrong.

Total number of connections we are trying to make is something around 300
concurrently.

Please suggest what should be do. This is very very urgent.

Regards,

Suprabhat

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2011-04-27 13:44:37 Re: BUG #5995: connection pooling not working
Previous Message lst_hoe02 2011-04-27 08:38:38 Re: validating database integrity

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2011-04-27 13:44:37 Re: BUG #5995: connection pooling not working
Previous Message Tom Lane 2011-04-26 21:48:50 Re: Setting timezone: is it bug or intended?