Comment by Twisell
20 hours ago
Why don't he use GROUP BY on indexed columns was my first thought also.
I guess we just have to patiently wait for the OP to hopefully read Postgres documentation from postgreSQL 10.x before correcting the article again.
> Why don't he use GROUP BY on indexed columns was my first thought also.
Because it has the same issue.
SELECT DISTINCT and GROUP BY are equivalent from a query planner perspective.
Does that fix it? Why would people be trying to add new index scanning modes if that's enough to fix it?
Someone else said it doesn't.