Re: foreign join error "variable not found in subplan target list"

Поиск
Список
Период
Сортировка
От Etsuro Fujita
Тема Re: foreign join error "variable not found in subplan target list"
Дата
Msg-id CAPmGK17zrx26KycGj+RB2YHuWW8-q7p8E3yFNKGgDEw+rX_QPA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: foreign join error "variable not found in subplan target list"  (Richard Guo <guofenglinux@gmail.com>)
Ответы Re: foreign join error "variable not found in subplan target list"  (Richard Guo <guofenglinux@gmail.com>)
Список pgsql-bugs
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 по дате отправления:

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Excessive number of replication slots for 12->14 logical replication
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: Excessive number of replication slots for 12->14 logical replication