Re: Fast COPY FROM based on batch insert

Поиск
Список
Период
Сортировка
От Ian Barwick
Тема Re: Fast COPY FROM based on batch insert
Дата
Msg-id 4ad1dcea-0eef-6ad4-8314-589dbceeebc5@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Fast COPY FROM based on batch insert  (Andrey Lepikhov <a.lepikhov@postgrespro.ru>)
Ответы Re: Fast COPY FROM based on batch insert  (Andrey Lepikhov <a.lepikhov@postgrespro.ru>)
Список pgsql-hackers
On 09/07/2022 00:09, Andrey Lepikhov wrote:
> On 8/7/2022 05:12, Ian Barwick wrote:
>>      ERROR:  bind message supplies 0 parameters, but prepared statement "pgsql_fdw_prep_178" requires 6
>>      CONTEXT:  remote SQL command: INSERT INTO public.foo_part_1(t, v1, v2, v3, v4, v5) VALUES ($1, $2, $3, $4, $5,
$6)
>>      COPY foo, line 88160
> Thanks, I got it. MultiInsertBuffer are created on the first non-zero flush of tuples into the partition and isn't
deletedfrom the buffers list until the end of COPY. And on a subsequent flush in the case of empty buffer we catch the
error.
> Your fix is correct, but I want to propose slightly different change (see in attachment).

LGTM.

Regards

Ian Barwick

--
https://www.enterprisedb.com/



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Allow file inclusion in pg_hba and pg_ident files