PostgreSQL High Performance Cookbook

Chapter 5. Connection Pooling and Database Partitioning

In this chapter, we will cover the following:

• Installing pgpool-II
• Configuring pgpool-II and testing the setup
• Installing PgBouncer
• Connection pooling using PgBouncer
• Managing Pgbouncer
• Implementing partitioning
• Managing artitions
• Installing PL/Proxy
• Partitioning with PL/Proxy

Introduction

pgpool-II is basically a middleware solution that works as an interface between a PostgreSQL server and a PostgreSQL client application. pgpool-II talks about the PostgreSQL's backend and frontend protocol and relays a connection between the two. pgpool-II caches incoming connections to PostgreSQL servers and reuses them whenever a new connection with the same properties comes in. This way it reduces connection overhead ...