PostgreSQL Replication - Second Edition

Understanding the features of pgpool

The following features are provided by pgpool:

• Connection pooling
• Statement-level replication
• Load balancing
• Limiting connections
• In-memory caching

Tip

When deciding which features to use, it is important to keep in mind that not all functionality is available at the same time. The following website contains an overview of what can go together and what cannot:

http://www.pgpool.net/docs/latest/pgpool-en.html#config.

One core feature of pgpool is the ability to do connection pooling. The idea is pretty much the same as the one we outlined in the previous chapter. We want to reduce the impact of forking connections each and every time a webpage is opened. Instead, we want to keep connections open and reuse them whenever ...