Topic: postgresql
-
Transaction isolation levels in practice
Read committed, repeatable read and serializable trade concurrency for consistency; knowing which anomalies each level allows decides when to add explicit locks or retries.
-
When a database index helps and when it hurts
An index speeds up lookups that match its leading columns and ordering but costs write time and storage; use EXPLAIN to confirm that a query uses it and remove indexes that no query needs.
-
Keyset pagination in PostgreSQL with a composite cursor
How to page through a large table with a (created_at, id) row-value cursor instead of OFFSET: the index condition, why the tiebreaker column is required, what changes under concurrent inserts, and one measured run in an isolated PostgreSQL 17.11 database.
Machine-readable: JSON