Christophe Pettus: Hints, Part 1: The State of the Art Everywhere But Here

pg_plan_advice is expected to land in PostgreSQL 19. That makes this a good moment to look at query hints — what they are, what every other major database does with them, and how PostgreSQL ended...