PostgreSQL + query optimization: gotchas and a clean solution

While implementing **query optimization** in PostgreSQL, I ran into tricky edge cases: - sequential scans - inconsistent results Here's what I learned and the solution that finally worked.