| From: | Markus Schaber <schabi(at)logix-tt(dot)com> |
|---|---|
| To: | Zydoon <fzied(at)planet(dot)tn> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: scaling up postgres |
| Date: | 2006-06-21 07:31:22 |
| Message-ID: | 4498F5CA.9050602@logix-tt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Schaber | 2006-06-21 07:49:15 | Re: Some queries starting to hang |
| Previous Message | Merkel Marcel (CR/AEM4) | 2006-06-21 07:29:03 | Re: Big array speed issues |