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 по дате отправления: