Tag

SQL Performance

A tag for finding articles about SQL Performance.

Browse by tag

There are currently 1 article with this tag. Use it when you want entries with a similar editorial angle.

Why PostgreSQL COUNT(DISTINCT) cannot use parallel aggregation—and how to rewrite it

PostgreSQL cannot use parallel aggregation when an aggregate call contains DISTINCT. Using the primary source’s execution plans and benchmark as the starting point, this article explains a GROUP BY rewrite, NULL semantics, and what to validate with EXPLAIN.

Database Postgresql

2026-08-06