| From: | Richard Guo <guofenglinux(at)gmail(dot)com> |
|---|---|
| To: | Alexander Pyhalov <a(dot)pyhalov(at)postgrespro(dot)ru> |
| Cc: | Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: foreign join error "variable not found in subplan target list" |
| Date: | 2022-08-12 03:09:50 |
| Message-ID: | CAMbWs4-01NoQ7LJg5jJu+dEOsB_-iC=7Xk6XNsyT2T_2BwOAzA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Wed, Aug 10, 2022 at 11:17 PM Alexander Pyhalov <a(dot)pyhalov(at)postgrespro(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Masahiko Sawada | 2022-08-12 03:28:15 | Re: BUG #17580: use pg_terminate_backend to terminate a wal sender process may wait a long time |
| Previous Message | Masahiko Sawada | 2022-08-12 01:28:02 | Re: Excessive number of replication slots for 12->14 logical replication |