Re: PosttgreSQL on AIX

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

In response to

Responses

Browse pgsql-general by date

  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?