Why I Use Partial Indexes for “Active Jobs” in Postgres
Keeping 50ms p95 while 8,000+ listings churn daily
Keeping 50ms p95 while 8,000+ listings churn daily
A decision framework for reliable events in Postgres-backed systems
A pragmatic way to prevent duplicate URLs from poisoning indexing
A solo-dev pattern for reliable emails and webhooks without a message bus
Production notes from a 7,556-job board with fast, typo-tolerant filters