← Back to context Comment by DiabloD3 18 hours ago The article seems to have changed since I commented. 4 comments DiabloD3 Reply Dylan16807 18 hours ago https://web.archive.org/web/20260814160231/https://www.dbos....It had the same stuff a month ago. Twisell 18 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. SkiFire13 14 hours ago > 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. Dylan16807 18 hours ago 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.
Dylan16807 18 hours ago https://web.archive.org/web/20260814160231/https://www.dbos....It had the same stuff a month ago.
Twisell 18 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. SkiFire13 14 hours ago > 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. Dylan16807 18 hours ago 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.
SkiFire13 14 hours ago > 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.
Dylan16807 18 hours ago 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.
https://web.archive.org/web/20260814160231/https://www.dbos....
It had the same stuff a month 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.