Re: System overload / context switching / oom, 8.3

From: Kevin Grittner
Subject: Re: System overload / context switching / oom, 8.3
Date: ,
Msg-id: 4B6836E3020000250002EE82@gw.wicourts.gov
(view: Whole thread, Raw)
In response to: System overload / context switching / oom, 8.3  (Rob)
Responses: Re: System overload / context switching / oom, 8.3  (Rob)
List: pgsql-performance

Tree view

System overload / context switching / oom, 8.3  (Rob, )
 Re: System overload / context switching / oom, 8.3  (Scott Marlowe, )
  Re: System overload / context switching / oom, 8.3  (Rob, )
 Re: System overload / context switching / oom, 8.3  ("Kevin Grittner", )
  Re: System overload / context switching / oom, 8.3  (Rob, )
 Re: System overload / context switching / oom, 8.3  (Andy Colson, )
 Re: System overload / context switching / oom, 8.3  (Andy Colson, )
  Re: System overload / context switching / oom, 8.3  (Greg Smith, )
  Re: System overload / context switching / oom, 8.3  (Robert Haas, )
  Re: System overload / context switching / oom, 8.3  (Rob Lemley, )
   Re: System overload / context switching / oom, 8.3  (Greg Smith, )
 Re: System overload / context switching / oom, 8.3  (Matthew Wakeling, )

Rob <> 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:

From: wyx6fox@sina.com
Date:
Subject: some problems when i use postgresql 8.4.2 in my projects .
From: "ramasubramanian"
Date:
Subject: Re: Queries within a function