Seven hours, one bad assumption
On Monday our QA manager reported a performance regression in an upcoming release. A feature flag that was supposed to improve query performance was actually making things worse. The feature controlled automatic date filtering - ensuring that queries always included a 90-day window at most, which meant the database could use its date-based partitions instead of scanning entire tables.