Module 10 of 10

Replication & Scaling

Lessons

About This Module

A single server is a single point of failure, and a single server can only do so much. This final module looks at how PostgreSQL deployments grow: keeping copies of your data on other servers, and spreading the work so the database keeps up as demand rises.

You'll start with replication, where a primary server sends its changes to one or more replicas for resilience and extra read capacity, and see how logical replication lets you copy chosen tables instead of the whole database. Then you'll look at ways of scaling: table partitioning to split very large tables into smaller pieces, and connection pooling to handle many clients without overloading the server.

That completes the lessons. Next, put everything together in the Projects section, where you'll build real things with PostgreSQL.

Lessons

4 videos
01

Set Up PostgreSQL Replication in 4 Steps [With Examples]

A tutorial on setting up replication between a primary and a replica server to provide high availability.

02

PostgreSQL Logical Replication Guide

What logical replication is, a step-by-step setup with publications and subscriptions, its limitations, how to monitor it, and the best use cases.

03

PostgreSQL Partitioning Tutorial

Learn which tables need partitioning and how to split a large table into smaller parts to keep queries and maintenance manageable.

04

PostgreSQL Connection Pooling Exhaustion: pgbouncer Max Client Tuning

A short look at why direct PostgreSQL connections are expensive and how PgBouncer connection pooling helps the server cope with traffic spikes.