Re: System overload / context switching / oom, 8.3

От: Kevin Grittner
Тема: Re: System overload / context switching / oom, 8.3
Дата: ,
Msg-id: 4B6836E3020000250002EE82@gw.wicourts.gov
(см: обсуждение, исходный текст)
Ответ на: System overload / context switching / oom, 8.3  (Rob)
Ответы: Re: System overload / context switching / oom, 8.3  (Rob)
Список: pgsql-performance

Скрыть дерево обсуждения

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 по дате сообщения:

От: wyx6fox@sina.com
Дата:
Сообщение: some problems when i use postgresql 8.4.2 in my projects .
От: "ramasubramanian"
Дата:
Сообщение: Re: Queries within a function