The JusDB Database Engineering Blog

Find the session behind a PostgreSQL lock wait with pg_blocking_pids, see why a waiting ALTER TABLE stalls every SELECT, and choose between cancel, terminate, and timeouts.

Use PostgreSQL advisory locks safely: session vs transaction locks, key choice, singleton jobs, leader election, and the PgBouncer, LIMIT, and lock-table traps.

Decide when a BRIN index can replace a B-tree on a time-ordered PostgreSQL table: check correlation, choose pages_per_range and an operator class, and roll it out safely.

Use pg_stat_io in PostgreSQL 16 to 18 to see whether client backends or the checkpointer do the writes, and to measure ring buffer, vacuum, extend, and WAL I/O.