On: Pg_hint_plan: Force PostgreSQL to execute query plans the way you want

[zac23or]

In my old tests, with data clustered by organization_id, the SQLite and SQLServer run the query very fast.

> is not to be so certain that there is "a correct query plan"

Yes, data distribution, type, row size, machine power, SSD vs HD can affect which is the “best plan”.