[HACKERS] Small improvement to parallel query docs - Mailing list pgsql-hackers

From David Rowley
Subject [HACKERS] Small improvement to parallel query docs
Date
Msg-id CAKJS1f81fob-M6RJyTVv3SCasxMuQpj37ReNOJ=tprhwd7hAVg@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] Small improvement to parallel query docs  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tomas Vondra pointed out to me that there's an error in parallel.sgml
which confuses the inner and outer sides of the join.

I've attached a patch which fixes this, although I think I'm still
missing the point to text's explanation of why Merge Join is not
included due to it having to sort the inner side in each worker. Hash
join must build a hash table for each worker, so why is that OK by
sorting is not?

Anyway, I've attached a patch which fixes the outer/inner confusion
and cleans up a couple of other grammar mistakes and an omissions
regarding DISTINCT and ORDER BY not being supported in parallel
aggregate. I ended up rewriting a section too which was explaining
parallel aggregate, which I personally believe is a bit more clear to
read, but someone else may think otherwise.

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Attachment

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: [HACKERS] Improve OR conditions on joined columns (common starschema problem)
Next
From: "Okano, Naoki"
Date:
Subject: Re: [HACKERS] Adding the optional clause 'AS' in CREATE TRIGGER