Postgresql

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.

PostgreSQL Index vs Full Scan: EXPLAIN ANALYZE on 100k / 1M / 5M Rows (Filter + ORDER BY + LIMIT)

7 February 2026·1832 words·9 mins

Guides PostgreSQL Performance Postgresql Performance Index Explain Sql Database

A reproducible lab showing how a composite index changes the execution plan from (parallel) seq scan + sort to index scan + limit, with EXPLAIN (ANALYZE, BUFFERS) evidence on 100k/1M/5M rows.

PostgreSQL Guides

1 January 0001·304 words·2 mins

Postgresql Guides

Scope # This section focuses on how PostgreSQL works and how to reason about it, not on benchmarks alone.