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: | Raw Message | Whole Thread | 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? |