Re: [POC] Fast COPY FROM command for the table with foreign partitions

From: Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>
To: "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>
Cc: "tanghy(dot)fnst(at)cn(dot)fujitsu(dot)com" <tanghy(dot)fnst(at)cn(dot)fujitsu(dot)com>, Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>, Michael Paquier <michael(at)paquier(dot)xyz>, Ashutosh Bapat <ashutosh(dot)bapat(at)2ndquadrant(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>, PostgreSQL-Dev <pgsql-hackers(at)postgresql(dot)org>, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, "houzj(dot)fnst(at)cn(dot)fujitsu(dot)com" <houzj(dot)fnst(at)cn(dot)fujitsu(dot)com>, Amit Langote <amitlangote09(at)gmail(dot)com>
Subject: Re: [POC] Fast COPY FROM command for the table with foreign partitions
Date: 2021-02-02 08:28:27
Message-ID: 95b3e446-92ec-f01f-2035-5f5509e6e016@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2/2/21 11:57, tsunakawa(dot)takay(at)fujitsu(dot)com wrote:
> Hello, Andrey-san,
>
>
> From: Tang, Haiying <tanghy(dot)fnst(at)cn(dot)fujitsu(dot)com>
>>> Sometimes before i suggested additional optimization [1] which can
>>> additionally speed up COPY by 2-4 times. Maybe you can perform the
>>> benchmark for this solution too?
> ...
>> But the patch no longer applies, I tried to apply on e42b3c3bd6(2021/1/26) but
>> failed.
>>
>> Can you send a rebased version?
> When do you think you can submit the rebased version of them? (IIUC at the off-list HighGo meeting, you're planning to post them late this week after the global snapshot patch.) Just in case you are not going to do them for the moment, can we rebase and/or further modify them so that they can be committed in PG 14?
Of course, you can rebase it.

--
regards,
Andrey Lepikhov
Postgres Professional

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2021-02-02 08:40:39 Re: Single transaction in the tablesync worker?
Previous Message Hou, Zhijie 2021-02-02 08:26:49 RE: Parallel INSERT (INTO ... SELECT ...)