Conference Schedule - PGConf.EU 2012Back
Boosting performance and reliablity by using pgpool-II
Date: Oct. 24, 2012
Pgpool-II offers several ways to enhance performance of PostgreSQL including connection pooling , load balancing and on memory query cache. In this presentation we focus on the query cache and explain how to configure, use and tune it to achieve better performance. Also we discuss how to avoid SPOF(Single Point Of Failure) of pgpool-II itself by using built in high availability functionality "watchdog" to manage pgpool-II cluster system.