News for hackers. Stuff that matters.
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.
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