Postgres Pro
Downloads
Home   >   mailing lists

Re: System overload / context switching / oom, 8.3 - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: System overload / context switching / oom, 8.3
Date
Msg-id 4B6836E3020000250002EE82@gw.wicourts.gov
Whole thread Raw
In response to System overload / context switching / oom, 8.3  (Rob <rclemley@yahoo.com>)
Responses Re: System overload / context switching / oom, 8.3  (Rob <rclemley@yahoo.com>)
List pgsql-performance
Tree view 
Rob <rclemley@yahoo.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

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: System overload / context switching / oom, 8.3
Next
From: Andy Colson
Date:
Subject: Re: System overload / context switching / oom, 8.3