Re: scaling up postgres

Поиск
Список
Период
Сортировка
От Markus Schaber
Тема Re: scaling up postgres
Дата
Msg-id 4498F5CA.9050602@logix-tt.com
обсуждение исходный текст
Ответ на Re: scaling up postgres  (Zydoon <fzied@planet.tn>)
Список pgsql-performance
Hi, Zydoon,

Zydoon wrote:

> Now I'm trying to make my tests, and I'm not that sure I will make the
> switch to the PSeries, since my dual xeon with 4 G RAM can handle 3500
> concurrent postmasters consuming 3.7 G of the RAM. I cannot reach this
> number on the PSeries with 2 G.

This sounds like you want to have one postgresql backend per apache
frontend.

Did you try running pgpool on the Apache machine, and have only a few
(hundred) connections to the backend?

Maybe http://en.wikipedia.org/wiki/Memcached could be helpful, too.


Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Merkel Marcel (CR/AEM4)"
Дата:
Сообщение: Re: Big array speed issues
Следующее
От: Markus Schaber
Дата:
Сообщение: Re: Some queries starting to hang