Advertisement

High Availability Procedures and Implementing a Pooler

  • Baji Shaik
Chapter
  • 47 Downloads

Abstract

In the last chapter, we talked about some basic things about MVCC in PostgreSQL, and what is bloat in the database and how it can be removed. We explained how autovacuum helps in removing bloat and improving performance. We also covered the best practices to execute maintenance activities like vacuum, reindex in detail. In this chapter, we will talk about the importance of High Availability (HA), and what information we need to build an HA solution and the procedures to implement it in PostgreSQL. We will cover some open source and enterprise tools to implement HA. We will also cover the importance of a pooler, and available poolers on the market and their implementation.

Copyright information

© Baji Shaik 2020

Authors and Affiliations

  • Baji Shaik
    • 1
  1. 1.HyderabadIndia

Personalised recommendations