Re: possible issue in postgres_fdw batching

2024-08-19 Thread Tomas Vondra
On 8/19/24 01:40, Tom Lane wrote: > Tomas Vondra writes: >> Consider this simplified example: > >> CREATE TABLE t (a INT); >> CREATE FOREIGN TABLE f (a INT) SERVER loopback >> OPTIONS (table_name 't'); >> CREATE FUNCTION counter() RETURNS int LANGUAGE sql AS

Re: possible issue in postgres_fdw batching

2024-08-18 Thread Tom Lane
Tomas Vondra writes: > Consider this simplified example: > CREATE TABLE t (a INT); > CREATE FOREIGN TABLE f (a INT) SERVER loopback > OPTIONS (table_name 't'); > CREATE FUNCTION counter() RETURNS int LANGUAGE sql AS > $$ SELECT COUNT(*) FROM f $$; > And n