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

Поиск
Список
Период
Сортировка
От tsunakawa.takay@fujitsu.com
Тема RE: [POC] Fast COPY FROM command for the table with foreign partitions
Дата
Msg-id TYAPR01MB29906DF706E88C5B2E574477FEB59@TYAPR01MB2990.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на RE: [POC] Fast COPY FROM command for the table with foreign partitions  ("Tang, Haiying" <tanghy.fnst@cn.fujitsu.com>)
Ответы Re: [POC] Fast COPY FROM command for the table with foreign partitions  (Andrey Lepikhov <a.lepikhov@postgrespro.ru>)
Список pgsql-hackers
Hello, Andrey-san,


From: Tang, Haiying <tanghy.fnst@cn.fujitsu.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?

I think the basic part of this patch set is the following.  The latter file unfortunately no longer applies to HEAD.

v13-0001-Move-multi-insert-decision-logic-into-executor.patch
v13_3-0002-Fast-COPY-FROM-into-the-foreign-or-sharded-table.patch

Plus, as Tang-san said, I'm afraid the following files are older and doesn't apply.

v9-0003-Add-separated-connections-into-the-postgres_fdw.patch
v9-0004-Optimized-version-of-the-Fast-COPY-FROM-feature

When do you think you can submit the rebased version of them?  (IIUC at the off-list HighGo meeting, you're planning to
postthem late this week after the global snapshot patch.)  Just in case you are not going to do them for the moment,
canwe rebase and/or further modify them so that they can be committed in PG 14?
 


Regards
Takayuki Tsunakawa




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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: Commitfest 2021-01 is now closed.
Следующее
От: "Joel Jacobson"
Дата:
Сообщение: Re: Recording foreign key relationships for the system catalogs