Vol. I · A Postgres Handbook

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

AdvancedAdvanced PostgreSQL

Theory: Table Partitioning

The query

SQL
-- Q: What is Declarative Partitioning?
-- A: Splitting a massive table into smaller, manageable physical tables 
-- (partitions) while treating them as a single logical table.
-- Types:
-- 1. RANGE (e.g., partitioning by month/year)
-- 2. LIST (e.g., partitioning by country or status)
-- 3. HASH (e.g., distributing data evenly across partitions based on a hash key)
Tested against PostgreSQL 16

Note

“Speeds up queries (Partition Pruning) and makes bulk deletion instant (Drop Partition).