Earlier quoted context omitted.
You've never run into a query planner that suddenly changes its mind once your tables grow. Try using row level security in postgres - it's awfully slow and you need to be a master architect and sql developer to make it run fast because it's too dumb on its own. With query planner hints I could at least guide it. Shame pg doesn't believe in that.
Poster said oracle not PG
Oracle has query hints; pg does not. Query planner hinters are useful. That's my point.