Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Pg_hint_plan: Force PostgreSQL to execute query plans the way you want. Parent comment
I did
> Postgres doesn’t automatically create indexes
Both fields have indexes (created manually). Postgres is incorrectly choosing the index in order by column, not the index in the where clause.
There are no comments on this comment yet.
I did
> Postgres doesn’t automatically create indexes
Both fields have indexes (created manually). Postgres is incorrectly choosing the index in order by column, not the index in the where clause.