[Pgpool-general] Pgpool with many inserts and updates
Josh Berkus
josh at agliodbs.com
Wed Mar 3 01:15:51 UTC 2010
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
More information about the Pgpool-general
mailing list