diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/contrib/postgres_fdw/results/postgres_fdw.out --- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-04-14 23:34:03.548742255 +0000 +++ /tmp/cirrus-ci-build/contrib/postgres_fdw/results/postgres_fdw.out 2025-04-14 23:41:16.635359485 +0000 @@ -2357,6 +2357,8 @@ -> Memoize Cache Key: t1.c2 Cache Mode: binary + Estimated Capacity: 10 Estimated Distinct Lookup Keys: 10 + Estimated Hit Ratio: 0.99 -> Subquery Scan on q -> HashAggregate Output: t2.c1, t3.c1 @@ -2365,7 +2367,7 @@ Output: t2.c1, t3.c1 Relations: (public.ft1 t2) INNER JOIN (public.ft2 t3) Remote SQL: SELECT r1."C 1", r2."C 1" FROM ("S 1"."T 1" r1 INNER JOIN "S 1"."T 1" r2 ON (((r2."C 1" = r1."C 1")) AND ((r1.c2 = $1::integer)))) -(17 rows) +(19 rows) SELECT t1."C 1" FROM "S 1"."T 1" t1, LATERAL (SELECT DISTINCT t2.c1, t3.c1 FROM ft1 t2, ft2 t3 WHERE t2.c1 = t3.c1 AND t2.c2 = t1.c2) q ORDER BY t1."C 1" OFFSET 10 LIMIT 10; C 1 @@ -3773,6 +3775,8 @@ Output: ref_1.c3, (ref_0.c2) Cache Key: ref_0.c2 Cache Mode: binary + Estimated Capacity: 6 Estimated Distinct Lookup Keys: 6 + Estimated Hit Ratio: 0.33 -> Foreign Scan on public.ft1 ref_1 Output: ref_1.c3, ref_0.c2 Remote SQL: SELECT c3 FROM "S 1"."T 1" WHERE ((c3 = '00001')) @@ -3781,7 +3785,7 @@ -> Foreign Scan on public.ft2 ref_3 Output: ref_3.c3 Remote SQL: SELECT c3 FROM "S 1"."T 1" WHERE ((c3 = '00001')) -(19 rows) +(21 rows) SELECT ref_0.c2, subq_1.* FROM