PostgreSQL Index Types: B-Tree, GIN, BRIN and Partial Indexes
Learn how B-Tree, GIN, BRIN and partial indexes work in PostgreSQL, when each fits your data and operators, and how to verify the choice with EXPLAIN.
14 min read
Tag
sql
Postgres SKIP LOCKED Queue: Build a Job Queue with Row-Level Locking
Build a Postgres job queue with FOR UPDATE SKIP LOCKED step by step: schema, dequeue query, worker models, retries, idempotency, vacuum and trade-offs.
14 min read