O'Reilly logo

PostgreSQL High Performance Cookbook by Dinesh Kumar, Chitij Chauhan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required