upvote
Postgres takes the actual values into account when generating a query plan. The same query with different params can (and should) result in different query plans. It looks at statistics on the actual data stored.
reply
With query hints finally being added it’d probably be doable as an extension
reply