Postgres Pro
Downloads
Home   >   mailing lists

Re: foreign join error "variable not found in subplan target list" - Mailing list pgsql-bugs

From Etsuro Fujita
Subject Re: foreign join error "variable not found in subplan target list"
Date
Msg-id CAPmGK17zrx26KycGj+RB2YHuWW8-q7p8E3yFNKGgDEw+rX_QPA@mail.gmail.com
Whole thread Raw
In response to Re: foreign join error "variable not found in subplan target list"  (Richard Guo <guofenglinux@gmail.com>)
Responses Re: foreign join error "variable not found in subplan target list"
List pgsql-bugs
Tree view 
On Mon, Aug 29, 2022 at 6:46 PM Richard Guo <guofenglinux@gmail.com> wrote:
> I'm looking again on how we adjust the PathTarget, and I think we may
> need to update the cost and width fields if there are any new columns
> added. Maybe we can leverage set_pathtarget_cost_width for that.

I'm not really sure we really need to make the estimates accurate,
because 1) the resulting EPQ plan is used only for rechecks, so the
estimates would not be that important IMO, and 2) in fact, we don't
adjust the estimates of a given EPQ plan in postgresGetForeignPlan()
even when replacing the plan's tlist and/or removing local conditions
from the plan.  Is it worth expending the cycles here?

Sorry for the late reply.

Best regards,
Etsuro Fujita

pgsql-bugs by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Excessive number of replication slots for 12->14 logical replication
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Excessive number of replication slots for 12->14 logical replication