Quick note #1 - Partial indexes
Recently, I faced the classical task scheduling issue, where a record needs to be processed after a specific date. Frequently, this scenario is implemented using a database table with a scheduled_at column coupled with a SELECT FOR UPDATE query. In this story, I'll use PostgreSQL syntax as