Tag
The article explains that PostgreSQL's SELECT DISTINCT clause does not scale efficiently, as it always scans all matching rows, leading to performance problems in certain workloads, and provides insights and workarounds.