Re:Postgres SELECT DISTINCT Does Not Scale
by atemerev on Saturday September 26, 2026 @05:01AM
(#49854602)
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.
[ Parent
| on HN ]
Re:Postgres SELECT DISTINCT Does Not Scale
by SkiFire13 on Saturday September 26, 2026 @06:10AM
(#49855027)
The manual workaround is even documented in postgres' wiki https://wiki.postgresql.org/wiki/Loose_indexscan