Hatchet
A guide to preventing Postgres from toppling over.
Welcome! Type "help" for available commands.
$
Summary
The article outlines unconventional PostgreSQL optimizations.
It covers using constraint_exclusion=on to skip full table scans on invalid values via check constraints. It also discusses function-based indexes with virtual generated columns for lower cardinality queries and hash indexes for uniqueness enforcement.
