Re: System overload / context switching / oom, 8.3

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-performance(at)postgresql(dot)org>,"Rob" <rclemley(at)yahoo(dot)com>
Subject: Re: System overload / context switching / oom, 8.3
Date: 2010-02-02 20:29:55
Message-ID: 4B6836E3020000250002EE82@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Rob <rclemley(at)yahoo(dot)com> wrote:

> 8gb ram
> ~240 active databases
> 800+ db connections via tcp.

8 GB RAM divided by 800 DB connections is 10 MB per connection. You
seriously need to find some way to use connection pooling. I'm not
sure the best way to do that with 240 active databases.

-Kevin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andy Colson 2010-02-02 20:36:20 Re: System overload / context switching / oom, 8.3
Previous Message Scott Marlowe 2010-02-02 20:25:28 Re: System overload / context switching / oom, 8.3