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 7. Working with Third-Party Replication Management Utilities

In this chapter, we will cover the following:

  • Setting up Barman
  • Backup and recovery using Barman
  • Setting up OmniPITR
  • WAL management with OmniPITR
  • Setting up Repmgr
  • Using Repmgr to create Replica
  • Setting up Walctl
  • Using Walctl to create Replica

Introduction

Indexes are in essence a database structure that speeds up fetching the data access operations. Indexes are basically used to boost database performance by rapidly locating data without having to search every row in the database table every time it is accessed. Data access via indexes is known as an indexed scan and it is used to provide random lookups and organized access of ordered records. In this chapter, we are going to talk about ...

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