Re: [Pgpool-general] Pgpool with many inserts and updates

2010-03-02 Thread Tatsuo Ishii
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.

Re: [Pgpool-general] Pgpool with many inserts and updates

2010-03-02 Thread Josh Berkus
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

Re: [Pgpool-general] Pgpool with many inserts and updates

2010-03-02 Thread Jaume Sabater
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