Comment by atemerev
15 hours ago
Well, if the solution is a manual workaround that forces a better query plan, this needs to be a part of Postgres itself so it builds better query plans automatically.
15 hours ago
Well, if the solution is a manual workaround that forces a better query plan, this needs to be a part of Postgres itself so it builds better query plans automatically.
The manual workaround is even documented in postgres' wiki https://wiki.postgresql.org/wiki/Loose_indexscan