PSQL: Use Argument Indexes
Stop repeating yourself
PSQL: Use Argument Indexes
Stop repeating yourself
PSQL: Use unlogged tables for caches
Trade crash-safety for speed
PSQL: Types By Category
Array, Boolean, String, Numeric, Composite, etc.
PSQL: Truncate Tables With Dependents
Truncate in pairs or via a cascade
PSQL: Truncate All Rows
Use truncate rather than delete