pg_plan_advice: Don't generate FOREIGN_JOIN advice for a single relation. A foreign scan can target a single relation while still reaching the fs_relids branch of pgpa_build_scan() -- for example, when postgres_fdw pushes an aggregate down over one foreign table. In that case, no advice should be emitted.
Author: Mahendra Singh Thalor <[email protected]> Co-authored-by: Robert Haas <[email protected]> Discussion: http://postgr.es/m/CAKYtNAofuAJBz6++SeikpCb=Y=mo1qgeuznj+kzop2johf1...@mail.gmail.com Branch ------ REL_19_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/89f5f860cc584cf4c531dbc38b614e4db5c61e24 Modified Files -------------- contrib/pg_plan_advice/Makefile | 4 +- contrib/pg_plan_advice/meson.build | 5 ++ contrib/pg_plan_advice/pgpa_scan.c | 8 ++- contrib/pg_plan_advice/t/001_foreign_scan.pl | 83 ++++++++++++++++++++++++++++ 4 files changed, 97 insertions(+), 3 deletions(-)
