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

Поиск
Список
Период
Сортировка
От Richard Guo
Тема Re: foreign join error "variable not found in subplan target list"
Дата
Msg-id CAMbWs4-01NoQ7LJg5jJu+dEOsB_-iC=7Xk6XNsyT2T_2BwOAzA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: foreign join error "variable not found in subplan target list"  (Alexander Pyhalov <a.pyhalov@postgrespro.ru>)
Список pgsql-bugs
Дерево обсуждения

On Wed, Aug 10, 2022 at 11:17 PM Alexander Pyhalov <a.pyhalov@postgrespro.ru> wrote:
OK. It looks good to me. The only thing which surprised me that in test
case we see unnecessary sort in remote query. However, it's explained by
selected costs and STD_FUZZ_FACTOR, so that sorted path has essentially
the same cost as non-sorted one according to
compare_path_costs_fuzzily().

Yeah, and meanwhile the sorted path is considered to have better
pathkeys than the non-sorted one. So it wins in add_path().

Thanks
Richard 

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: Excessive number of replication slots for 12->14 logical replication
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: BUG #17580: use pg_terminate_backend to terminate a wal sender process may wait a long time