.tips
page 10 of 10, 238 small things in all. back to the first.
.november
2025, 13 tips.
Transaction pooling breaks session state, plan for it
postgresqloperationsTune autovacuum per table, not globally
postgresqloperationsINCLUDE the columns the query reads as well as the ones it filters
postgresqlperformanceLIKE '%term%' needs a trigram index
postgresqlsearchLet a generated column hold the derived value
postgresqlschema-designUse jsonb_path_ops for containment queries
postgresqlperformanceFix bad row estimates with CREATE STATISTICS
postgresqlperformanceRead wait_event before you guess why a query is slow
postgresqldebuggingGive the app role a statement_timeout
postgresqloperationsKill sessions that sit idle inside a transaction
postgresqloperationsAdd constraints as NOT VALID, then VALIDATE
postgresqlmigrationsSet lock_timeout before any ALTER TABLE
postgresqlmigrationsNever build an index on a live table without CONCURRENTLY
postgresqlmigrations