I wrote: > Really? Maybe I misunderstand the case under consideration, but > what I think will be happening is that each worker will re-execute > the pushed-down subquery in full.
Oh ... nevermind that: what I was thinking about was the SubLink/SubPlan case, which is unrelated to SubqueryScan. -ENOCAFFEINE, sorry about that. regards, tom lane