pumarogie

designing-postgres-schemas

Use when creating tables, choosing primary keys, picking column types, deciding on foreign keys, or reaching for a jsonb column in Postgres.

postgres-advanced-patterns

Use when building a job queue in Postgres, leasing rows across workers, partitioning time-series data, bulk-writing rows, or migrating data between large tables.

tuning-autovacuum-and-bloat

Use when writes outpace vacuum, autovacuum runs for a long time, transaction-ID wraparound is a risk, or tables and indexes are bloating on disk.

writing-performant-queries

Use when a query is slow, doing a sequential scan, or when writing SELECTs, JOINs, ORDER BY, or adding indexes in Postgres.

writing-safe-migrations

Use when altering tables, adding indexes or constraints, or writing any Postgres migration that runs against a large or live table.

managing-postgres-connections

Use when configuring a Postgres connection pool, hitting max connection limits, seeing connection churn, or debugging connection-storm errors.