Re: [HACKERS] Parallel appendrel scans?

[Robert Haas]

On Jul 3, 2016, at 6:58 PM, Tom Lane  wrote:
> It looks to me like set_append_rel_pathlist builds a partial path for
> an appendrel only if there exist partial paths for all members of the
> appendrel.  I don't understand this restriction.  Why could you not
> build it from a regular path for each appendrel child?  You'd have
> to farm out entire childrels to workers, which might be larger chunks
> of work than one could wish, but it seems better than failing to
> parallelize at all.

Absolutely.  The problem is merely that we need some executor support that has 
not been written yet. See discussions of Parallel Append in the archives.

...Robert

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

[HACKERS] Parallel appendrel scans?

[Tom Lane]

It looks to me like set_append_rel_pathlist builds a partial path for
an appendrel only if there exist partial paths for all members of the
appendrel.  I don't understand this restriction.  Why could you not
build it from a regular path for each appendrel child?  You'd have
to farm out entire childrels to workers, which might be larger chunks
of work than one could wish, but it seems better than failing to
parallelize at all.

regards, tom lane


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