Re: Fast COPY FROM based on batch insert

Поиск
Список
Период
Сортировка
От Etsuro Fujita
Тема Re: Fast COPY FROM based on batch insert
Дата
Msg-id CAPmGK163tgpiMoacE9maeEL-L9oRJ4kQb36QW77gYh0qWzChww@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Fast COPY FROM based on batch insert  (Andrey Lepikhov <a.lepikhov@postgrespro.ru>)
Список pgsql-hackers
On Fri, Oct 28, 2022 at 7:53 PM Andrey Lepikhov
<a.lepikhov@postgrespro.ru> wrote:
> On 28/10/2022 16:12, Etsuro Fujita wrote:
> > I think there is another patch that improves performance of COPY FROM
> > for foreign tables using COPY FROM STDIN, but if Andrey (or anyone
> > else) want to work on it again, I think it would be better to create a
> > new CF entry for it (and start a new thread for it).  So I plan to
> > close this in the November CF unless they think otherwise.

> I studied performance of this code in comparison to bulk INSERTions.
> This patch seems to improve speed of insertion by about 20%. Also, this
> patch is very invasive. So, I don't have any plans to work on it now.

Ok, let's leave that for future work.  I closed this entry in the November CF.

Best regards,
Etsuro Fujita



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

Предыдущее
От: Dilip Kumar
Дата:
Сообщение: Re: Segfault on logical replication to partitioned table with foreign children
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Simplifying our Trap/Assert infrastructure