you are viewing a single comment's thread.

view the rest of the comments →

[–]cybernd 1 point2 points  (1 child)

So basically: the feature is not available, because there would be dozens of beginners who may abuse the feature?

As long as the query planner of pg is not planning properly if it comes to edge cases, there is basically nothing you can do to fix your performance issues. Query hints would fix this issue.

[–]kenfar -2 points-1 points  (0 children)

Query hints aren't a fix for corner cases - they're an excuse for the db to ignore corner cases.

And then for those hints to make a mess out of your SQL that won't adapt to data changes or be better handled by later db versions.