Skip to main content

Postgres how-to guides

TBD

Table of Contents​

postgres-howtos/
├── tuning/
│ └── initial-postgres-tuning → Your "first aid kit" 🚑
├── query-optimization/
│ ├── pg-stat-statements → Your "diagnostic imaging" 🔍
│ └── long-running-transactions → The "heart attack" scenario ❤️‍🩹
├── bloat/
│ └── dealing-with-bloat → The "cholesterol" problem 🩺
└── replication/
└── replication-lag-troubleshooting → The "circulation system" 🫀

Tuning​

Essential configuration and performance tuning guides:

Initial Postgres tuning​

Your "first aid kit" - the 80/20 rule for immediate performance improvements on any new Postgres installation.

Query Optimization​

Tools and techniques for query performance analysis and optimization:

Working with pg_stat_statements​

Your "diagnostic imaging" tool - the single most important extension for query performance analysis and database health monitoring.

Dealing with long-running transactions​

Emergency response and prevention for transactions that can bring your OLTP system down - the "heart attack" scenario.

Bloat​

Database maintenance and cleanup guides:

Dealing with bloat​

Diagnose, treat, and prevent the "cholesterol" of databases - bloat that silently degrades performance over time.

Replication​

High availability and replication management:

Troubleshooting streaming replication lag​

Monitor, diagnose, and fix the "circulation system" of your Postgres cluster before replication issues impact availability.