postgresql.org

Replicate specific tables to another PostgreSQL instance with logical replication (publication/subscription)

Partition a large PostgreSQL table with declarative range partitioning

Upsert rows in PostgreSQL with INSERT ... ON CONFLICT, and when to use MERGE instead

Back up and restore a PostgreSQL database with pg_dump and pg_restore

Bulk-load data into PostgreSQL fast with COPY and psql \copy

Reclaim space and keep planner statistics fresh in PostgreSQL with VACUUM, ANALYZE, and autovacuum

Build or rebuild a PostgreSQL index on a production table without blocking writes using CREATE INDEX CONCURRENTLY and REINDEX CONCURRENTLY

Find and stop long-running or stuck queries in PostgreSQL with pg_stat_activity, pg_cancel_backend, and pg_terminate_backend

Find the most expensive queries in a PostgreSQL database with pg_stat_statements

Diagnose a slow PostgreSQL query with EXPLAIN and EXPLAIN ANALYZE, reading buffer statistics and actual-vs-estimated row counts

Use PostgreSQL logical replication to perform a zero-downtime major-version upgrade

Configure quorum-based synchronous replication in PostgreSQL with synchronous_standby_names ANY

Set up cascading PostgreSQL streaming replication where a standby relays WAL to downstream standbys

Set up Postgres continuous archiving (WAL archiving + pg_basebackup) for PITR