Open Challenges

A large catalog feed works for shallow browsing but slows down as clients page deeper into a hot category. Redesign pagination so latency stays predictable.

A support portal search migrated to Postgres full-text search two weeks ago and has been silently broken ever since. Your task is to improve the search quality.

Your transaction log queries are grinding to a halt as the table grows. Implement PostgreSQL table partitioning to bring date-range queries back under 1 second.

It's Black Friday and your authentication system is crashing! Users are waiting 10+ seconds to log in because of a missing database index. Learn how to diagnose and fix this critical performance issue.

Implement the transactional outbox pattern to reliably publish events to Kafka after a database write.