Re: PosttgreSQL on AIX - Mailing list pgsql-general

From Ernesto Quiñones
Subject Re: PosttgreSQL on AIX
Date
Msg-id AANLkTimJct4SS0WwM5-7BH7af7GOlwO9R0P3cSe2uNY6@mail.gmail.com
Whole thread Raw
In response to Re: PosttgreSQL on AIX  (John R Pierce <pierce@hogranch.com>)
Responses Re: PosttgreSQL on AIX
List 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@hogranch.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@postgresql.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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Disable executing external commands from psql?
Next
From: Tom Lane
Date:
Subject: Re: Disable executing external commands from psql?