RE: batch fdw insert bug (Postgres 14)

2021-05-09 Thread tsunakawa.ta...@fujitsu.com
From: Tomas Vondra > I think the simplest fix is simply to pstrdup() the query when building > fmstate in create_foreign_modify. We've already been doing that for > orig_query anyway. That seems cleaner than printing the last query we > build (which would be confusing I think). > > I've pushed a

Re: batch fdw insert bug (Postgres 14)

2021-05-07 Thread Pavel Stehule
pá 7. 5. 2021 v 22:43 odesílatel Tomas Vondra napsal: > > On 5/7/21 2:46 PM, houzj.f...@fujitsu.com wrote: > > > >> 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 > >> > -

Re: batch fdw insert bug (Postgres 14)

2021-05-07 Thread Tomas Vondra
On 5/7/21 2:46 PM, houzj.f...@fujitsu.com wrote: 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 --

RE: batch fdw insert bug (Postgres 14)

2021-05-07 Thread houzj.f...@fujitsu.com
> 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.vzdalen

Re: batch fdw insert bug (Postgres 14)

2021-05-07 Thread Pavel Stehule
pá 7. 5. 2021 v 11:48 odesílatel Pavel Stehule napsal: > 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 > > > -

batch fdw insert bug (Postgres 14)

2021-05-07 Thread Pavel Stehule
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_ta