[Pgpool-general] What is the performance penalty of using pgpool

ram ram at netcore.co.in
Wed Aug 12 11:20:21 UTC 2009


Hi,

I am supposed to implement some database replication , in order to have
a real time data backup. 
I tried out pgpool in a test environment and benchmarking with pgbench I
realized that the time for inserts would grow by an average 100% with
pgpool.

https://ecm.netcore.co.in/tmp/postgres_pgpool_comparison.html


But that would mean my application would get thrashed for time. 
I am new to postgres & pgpool ( had been using mysql all the while) 

Can someone guide me is this time difference normal. Where do I look for
any tuning ? 



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090812/507f6701/attachment.html>


More information about the Pgpool-general mailing list