> 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