News for hackers. Stuff that matters.
Re:Pg_hint_plan: Force PostgreSQL to execute query plans the... by zac23or on Saturday March 16, 2024 @03:01PM (#39728515)
>Pg stats are messed up somehow. Try running explain analyze foo

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.