PosttgreSQL on AIX

=?ISO-8859-1?Q?Ernesto_Qui=F1ones?= <ernestoq@gmail.com> writes:

Hi friends I need to configure two PgSQl servers on AIX working with a SAN
I need to know how easy is compile PostgreSQL on AIx, some special
consideration?

http://www.postgresql.org/docs/8.4/static/installation-platform-notes.html#INSTALLATION-NOTES-AIX

regards, tom lane

Hi Tom, I read the page before, thanks

maybe some friend can recommend me some "load balancer" solution for
AIX with PostgreSQL

thanks

2010/6/1 Tom Lane <tgl@sss.pgh.pa.us>:

=?ISO-8859-1?Q?Ernesto_Qui=F1ones?= <ernestoq@gmail.com> writes:

Hi friends I need to configure two PgSQl servers on AIX working with a SAN
I need to know how easy is compile PostgreSQL on AIx, some special
consideration?

http://www.postgresql.org/docs/8.4/static/installation-platform-notes.html#INSTALLATION-NOTES-AIX

                       regards, tom lane

--
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

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.

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

Ernesto Quiñones wrote:

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?

good luck. replace those weak PPC boxes with a single proper Power6 or
Power7 system and run circles around them.

How many concurrence can support a server with 4 PPC Power 6 and 16GB RAM??!!

I was thinking install the load balancing in this machine but maybe I
could run PostgreSQL in this machine without problems for my
concurrence

2010/6/1 John R Pierce <pierce@hogranch.com>:

Ernesto Quiñones wrote:

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?

good luck.   replace those weak PPC boxes with a single proper Power6 or
Power7 system and run circles around them.

--
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

Ernesto Quiñones wrote:

How many concurrence can support a server with 4 PPC Power 6 and 16GB RAM??!!

I was thinking install the load balancing in this machine but maybe I
could run PostgreSQL in this machine without problems for my
concurrence

Power 6 and Powerpc are two completely different chips, albeit with the
same basic instruction set.
PowerPC are typically used in blades, while the Power 6 and 7 are used
in systems like Power 520, 550, 750, etc.

the number of concurrent accesses a server can handle is heavily
dependent on

A) the nature of the query workload
B) the speed of the IO system, especially committed random writes/second

IBM will often loan hardware for performance testing.

On Tue, Jun 1, 2010 at 8:39 PM, Ernesto Quiñones <ernestoq@gmail.com> wrote:

How  many concurrence can support a server with 4 PPC Power 6 and 16GB RAM??!!

I was thinking install the load balancing in this machine but maybe I
could run PostgreSQL in this machine without problems for my
concurrence

For basic concurrency estimation you would need:
*) number of concurrent connections:
*) number of concurrent active users:
*) rough estimation of expected transactions per second
*) rough estimation of how much work (cpu, disk) for each user

300 users working at once can be handled from one server but is
getting close to where you should start thinking about a connection
pooler. The best (IMO) pooler is pgbouncer but it uses libevent which
does not list AIX under supported platforms
(http://www.monkey.org/~provos/libevent/).

Connection pooler is not a load balancer. A pooler reduces the number
of connections to the database making kernel configuration and dealing
with high load situations easier.

merlin

It's possible runs pgPool-II on AIX??

thanks

2010/6/2 Merlin Moncure <mmoncure@gmail.com>:

On Tue, Jun 1, 2010 at 8:39 PM, Ernesto Quiñones <ernestoq@gmail.com> wrote:

How  many concurrence can support a server with 4 PPC Power 6 and 16GB RAM??!!

I was thinking install the load balancing in this machine but maybe I
could run PostgreSQL in this machine without problems for my
concurrence

For basic concurrency estimation you would need:
*) number of concurrent connections:
*) number of concurrent active users:
*) rough estimation of expected transactions per second
*) rough estimation of how much work (cpu, disk) for each user

300 users working at once can be handled from one server but is
getting close to where you should start thinking about a connection
pooler.  The best (IMO) pooler is pgbouncer but it uses libevent which
does not list AIX under supported platforms
(http://www.monkey.org/~provos/libevent/).

Connection pooler is not a load balancer.  A pooler reduces the number
of connections to the database making kernel configuration and dealing
with high load situations easier.

merlin

--
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

On Wed, Jun 2, 2010 at 10:53 AM, Ernesto Quiñones <ernestoq@gmail.com> wrote:

It's possible runs pgPool-II on AIX??

It looks like it does.

merlin