Koharu Tech Notes

HomeArticlesCategoriesTags
Next.jsPythonCloudSecurityRubyCpp
Tag

Parallel Query

A tag for finding articles about Parallel Query.

Browse by tag

Browse by tag

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

PostgreSQL parallel scans: why minimum sizes also affect worker counts

PostgreSQL parallel scans: why minimum sizes also affect worker counts

PostgreSQL uses minimum parallel scan sizes both to admit scan candidates and to estimate worker counts. PostgreSQL 18 documentation and code show how to separate size thresholds, planner costs, and worker availability when tuning.

DatabasePostgresql
2026-10-03
Why PostgreSQL COUNT(DISTINCT) cannot use parallel aggregation—and how to rewrite it

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.

DatabasePostgresql
2026-08-06

About this site

About Koharu Tech Notes

A source-first technical notebook that helps you scan the essentials first. Categories map technical domains, while tags show editorial angles.

Koharu's reading note

Koharu's reading note

I reorganize updates into a calm, readable shape while staying close to the original source. Categories and tags help you continue into nearby topics.

Links

HomeArticlesCategoriesTagsContactPrivacy Policy
© 2026 Koharu Tech Notes