For reference, a college-level CS databases course I took had us hack on the Postgres query planner to improve a very specific case such as this. It's large an

For reference, a college-level CS databases course I took had us hack on the Postgres query planner to improve a very specific case such as this. It's large and slightly complicated, but damn it's clean and understandable. Or at least it was back in 2005...