Обсуждение: PosttgreSQL on AIX
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? is possible to run pgcluster only balnacer) or pgpool-II in aix? thanks -- 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
=?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