Re: Foreign join search stops on the first try

Ashutosh Bapat писал 2022-01-25 17:08: This code was written long ago. So I may have some recollection errors. But AFAIR, the reasons we wanted to avoid repeated estimation/planning for the same foreign join rel were 1. If use_remote_estimate = true, we fetch EXPLAIN output from the foreign serve

Re: Foreign join search stops on the first try

This code was written long ago. So I may have some recollection errors. But AFAIR, the reasons we wanted to avoid repeated estimation/planning for the same foreign join rel were 1. If use_remote_estimate = true, we fetch EXPLAIN output from the foreign server for various pathkeys. Fetching EXPLAIN

Foreign join search stops on the first try

Hi. I was investigating why foreign join is not happening and found the following issue. When we search for foreign join path we stop on the first try. For example, in case A JOIN B JOIN C where all of them are foreign tables on the same server firstly we estimate A JOIN B, A JOIN C and B JOIN