Show HN: pg_flame – flamegraph visualizations of PostgreSQL query plans
A really great feature that the Oracle database has is ability to provide hints to the planner. Is there anything that prevents PostgreSQL from adding this feature?<p>edit: Googled it, looks like PostgreSQL maintainers just have an opinion that hints are bad and the planner is good enough:<p><a href="https://wiki.postgresql.org/wiki/OptimizerHintsDiscussion" rel="nofollow">https://wiki.postgresql.org/wiki/OptimizerHintsDiscussion</a><p>There are "Explicit JOINs" but I'm not sure how useful they are:<p><a href="https://www.postgresql.org/docs/current/explicit-joins.html" rel="nofollow">https://www.postgresql.org/docs/current/explicit-joins.html</a>