batch fdw insert bug (Postgres 14) - Mailing list pgsql-hackers

From Pavel Stehule
Subject batch fdw insert bug (Postgres 14)
Date
Msg-id CAFj8pRCL_Rjw-MCR6J7VX9OF7MR6PA5K8qUbrMvprW_e-aHkfQ@mail.gmail.com
Whole thread Raw
Responses Re: batch fdw insert bug (Postgres 14)
List pgsql-hackers
Hi

I am testing new features in Postgres 14, and I found bug

EXPLAIN ANALYZE VERBOSE  for insert to FDW table with batch_size 1000 returns

-------------------------------------------------------------------------------------------------------------------------------
 Insert on public.vzdalena_tabulka2  (cost=0.00..175.00 rows=0 width=0) (actual time=30.269..30.270 rows=0 loops=1)
   Remote SQL: \x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F
   Batch Size: 1000
   ->  Function Scan on pg_catalog.generate_series g  (cost=0.00..175.00 rows=10000 width=36) (actual time=0.453..1.988 rows=10
         Output: g.i, ('AHOJ'::text || (g.i)::text)
         Function Call: generate_series(1, 10000)
 Planning Time: 0.075 ms
 Execution Time: 31.032 ms
(8 rows)

Regards

Pavel

pgsql-hackers by date:

Previous
From: Michail Nikolaev
Date:
Subject: Re: [PATCH] Full support for index LP_DEAD hint bits on standby
Next
From: Andrey Lepikhov
Date:
Subject: Re: Asynchronous Append on postgres_fdw nodes.