Re: Fix generate_useful_gather_paths for parallel unsafe pathkeys

Tomas Vondra <tomas.vondra@enterprisedb.com>

From: Tomas Vondra <tomas.vondra@enterprisedb.com>

To: James Coleman <jtc331@gmail.com>

Cc: pgsql-hackers <pgsql-hackers@postgresql.org>, luis.roberto@siscobra.com.br, Tom Lane <tgl@sss.pgh.pa.us>, Robert Haas <robertmhaas@gmail.com>

Date: 2020-12-22T01:07:09Z

Lists: pgsql-hackers

Hi,

I've pushed (and backpatched) all the fixes posted to this thread. I 
believe that covers all the incremental sort fixes, so I've marked [1] 
as committed.

[1] https://commitfest.postgresql.org/31/2754/


regards

-- 
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Commits

Improve find_em_expr_usable_for_sorting_rel comment
- 336879f5557e 13.2 landed
- 1ca2eb103113 14.0 landed
Don't search for volatile expr in find_em_expr_usable_for_sorting_rel
- aa97890b6ec2 13.2 landed
- 9aff4dc01fbb 14.0 landed
Disallow SRFs when considering sorts below Gather Merge
- fac1b470a9f7 14.0 landed
- d0167631e8b7 13.2 landed
Check parallel safety in generate_useful_gather_paths
- be9c3cd186ba 13.2 landed
- 86b7cca72d4d 14.0 landed
Consider unsorted paths in generate_useful_gather_paths
- ea190ed14b4b 13.2 landed
- f4a3c0b06250 14.0 landed
Error out when Gather Merge input is not sorted
- 6bc27698324a 14.0 landed