Elizabeth Garrett Christensen: Query Plan Hints in PostgreSQL 19: How & When to Use Advice

From Planet PostgreSQL

Query hints: You asked for it, Postgres 19 gave it to you. Now, they are just waiting to see how you use it. For years the Postgres community was against adding support for hints. They felt if you had correctly analyzed tables, the Postgres query planner would make the right choice. And they're not wrong, for the most part. Yet…

— Planet PostgreSQL. Read the full story ↗