Re: System overload / context switching / oom, 8.3

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

Kevin Grittner wrote:
> 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.
>

By wrangling the applications, We've got the number of connections down
to 530 and number of active databases down to 186.

The application's poor connection management exacerbates the problem.

Thanks for the idea,
Rob

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2010-02-03 00:14:14 Re: queries with subquery constraints on partitioned tables not optimized?
Previous Message Rob 2010-02-02 21:44:36 Re: System overload / context switching / oom, 8.3