| From: | Ernesto Quiñones <ernestoq(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PosttgreSQL on AIX |
| Date: | 2010-06-02 00:28:54 |
| Message-ID: | AANLkTimJct4SS0WwM5-7BH7af7GOlwO9R0P3cSe2uNY6@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
The "architecture" that I need to install is:
1 AIX ----------> 3 AIX --------------> 1
load servers Storage
balancer with PostgreSQL (SAN)
the 3 AIX PostgreSQL are PPC RS64-III with 1gb RAM
the concurrence is near to 250 - 300 connections (the total user is
bigger than 32,000)
some idea/advice?
thanks
pd. sorry my bad english
2010/6/1 John R Pierce <pierce(at)hogranch(dot)com>:
> Ernesto Quiñones wrote:
>>
>> Hi Tom, I read the page before, thanks
>>
>> maybe some friend can recommend me some "load balancer" solution for
>> AIX with PostgreSQL
>>
>
> load balancing writes is problematic. load balancing reads is easy enough,
> although maintaining ACID with decent performance can still be problematic,
> depending on how you do the replication from the writable master to the
> readonly slave
>
> one bigger-faster AIX box or LPAR will likely be faster than two slower
> ones, no matter how you load balance it.
>
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Inscríbete en las listas de APESOL
http://www.apesol.org/listas.php
----------------------------------------------------------
Visita : http://www.eqsoft.net
----------------------------------------------------------
Sigueme en Twitter : http://www.twitter.com/ernestoq
----------------------------------------------------------
Noticias de software libre : http://www.twitter.com/noticiapinguino
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-06-02 00:30:21 | Re: Disable executing external commands from psql? |
| Previous Message | Bruce Momjian | 2010-06-02 00:26:21 | Re: Disable executing external commands from psql? |