Labs

Table of Contents

What you will find here
#

Labs are hands-on, reproducible experiments. Each lab typically includes:

Environment (versions, deployment model)
Steps to reproduce
Before/after evidence (e.g., EXPLAIN / EXPLAIN ANALYZE)
Metrics (execution time, buffers, key observations)
Takeaways you can apply in production and in interviews

Topics
#

PostgreSQL Labs
(coming next) MySQL Labs
(coming next) AWS RDS/Aurora Labs

PostgreSQL Labs

7 February 2026·47 words·1 min

Postgresql Labs

Focus areas # Query planning: EXPLAIN / EXPLAIN ANALYZE Index design and trade-offs (composite indexes, index-only scans) JSONB and GIN indexing patterns Locking and concurrency diagnostics Practical performance workflows (plan → hypothesis → change → validate) Labs # Below are the PostgreSQL labs available on this site.

↑

What you will find here #

Topics #

What you will find here
#

Topics
#