Get the latest tech news
The DISTINCT in Your COUNT
COUNT(DISTINCT) has no combine function, so PostgreSQL can't merge per-worker results: the whole statement drops to one core and a disk-spilling sort. Push the distinctness into a GROUP BY instead and parallel query comes back.
None
Or read this on Hacker News
