Re: [Pgpool-general] Pgpool with many inserts and updates
I've just finished reading http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html and http://pgpool.projects.postgresql.org/pgpool-II/doc/tutorial-en.html but I'm still very new pgpool so please be patient. Just looking for some pointers to steer me in the right direction. What's the best setup for pgpool when your database has a lot of inserts and updates? Pgpool-II does not enhance write performance of PostgreSQL. You will get write performance of roughly 60-70% of PostgreSQL when pgpool-II is running in repication mode. With master/slave mode + Slony-I you could obtain better than it, still it is slightly lower than 100%. So first thing you should do is, to prepare good hardwares and to tune PostgreSQL to get enough write performance for your applications. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
Re: [Pgpool-general] Pgpool with many inserts and updates
Tatsuo, Pgpool-II does not enhance write performance of PostgreSQL. You will get write performance of roughly 60-70% of PostgreSQL when pgpool-II is running in repication mode. With master/slave mode + Slony-I you could obtain better than it, still it is slightly lower than 100%. So first thing you should do is, to prepare good hardwares and to tune PostgreSQL to get enough write performance for your applications. Wait, we take a 30% hit for pgPool2? Seems quite large ... the overhead for pgPool1 in replication mode was much lower. What accounts for the overhead? --Josh Berkus ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
Re: [Pgpool-general] Pgpool with many inserts and updates
On Wed, Mar 3, 2010 at 2:15 AM, Josh Berkus j...@agliodbs.com wrote: Pgpool-II does not enhance write performance of PostgreSQL. You will get write performance of roughly 60-70% of PostgreSQL when pgpool-II is running in repication mode. With master/slave mode + Slony-I you could obtain better than it, still it is slightly lower than 100%. So first thing you should do is, to prepare good hardwares and to tune PostgreSQL to get enough write performance for your applications. Wait, we take a 30% hit for pgPool2? Seems quite large ... the overhead for pgPool1 in replication mode was much lower. What accounts for the overhead? The fact that it's a synchronous cluster, i.e. writes are committed to all nodes, then ACK is returned to the client (actually it's firs the master, then all the slaves, then ACK to the client). -- Jaume Sabater http://linuxsilo.net/ Ubi sapientas ibi libertas ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
