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

Re: [Fwd: postgres 8.4.1 number of connections]

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Maria(dot)L(dot)Wilson-1(at)nasa(dot)gov
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [Fwd: postgres 8.4.1 number of connections]
Date: 2010-08-26 21:13:44
Message-ID: AANLkTikkCJ1embk=i6V06k7sRQqv3WfGGwPLNGTGuMWV@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, Aug 26, 2010 at 2:29 PM, Maria L. Wilson
<Maria(dot)L(dot)Wilson-1(at)nasa(dot)gov> wrote:
>
>
> we have this application (using jboss/java/hibernate) on linux accessing
> data on 3 postgres database servers using 8.4.1.
>
> One of our many concerns has been the way we handle connections to the
> database.  java/hibernate handle their own pooling so I understand that
> using anything else is out of the question.

It's not impossible to put another connection pooler between hibernate
and your database server.  May not be useful or better, but it's
possible.

>  Our jboss configuration
> currently defaults to 5 connections per database.

I assume this is for each app server.  How many app servers do you have?

>  On our main database
> server, we handle 7 of the databases that this application uses.  On
> this one server, we usually average around 300 - 500 connections to the
> server.  In our postgres conf file on this particular machine we set the
> max_connection parameter to 1000.  If we set it to much lower we end up
> with connection errors.  Any comments or better way to handle this?

Other than breaking out the databases onto their own server, or trying
to pool to fewer connections, not really.  OTOH, a db server with
enough memory can handle having that many connections as long as you
don't run into any thundering herd issues.

Oh, and you should really update your pgsql to 8.4.4.  8.4.1 had some
issues with heavy load I ran into last year about this time.  Which is
why I'm still on 8.3.11

--
To understand recursion, one must first understand recursion.

In response to

Responses

pgsql-performance by date

Next:From: Ozer, PamDate: 2010-08-27 00:03:27
Subject: Slow Query
Previous:From: Maria L. WilsonDate: 2010-08-26 20:29:31
Subject: [Fwd: postgres 8.4.1 number of connections]

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