RE: Parallel INSERT (INTO ... SELECT ...)

From: "tanghy(dot)fnst(at)fujitsu(dot)com" <tanghy(dot)fnst(at)fujitsu(dot)com>
To: "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Cc: "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>, 'Amit Kapila' <amit(dot)kapila16(at)gmail(dot)com>, Greg Nancarrow <gregn4422(at)gmail(dot)com>, Antonin Houska <ah(at)cybertec(dot)at>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Amit Langote <amitlangote09(at)gmail(dot)com>
Subject: RE: Parallel INSERT (INTO ... SELECT ...)
Date: 2021-02-26 09:23:55
Message-ID: OS0PR01MB6113734A4D3BD316A190C40AFB9D9@OS0PR01MB6113.jpnprd01.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

From: Tsunakawa, Takayuki/綱川 貴之 <tsunakawa(dot)takay(at)fujitsu(dot)com>
>the current patch showd nice performance improvement in some (many?) patterns.
>So, I think it can be committed in PG 14, when it has addressed the plan cache issue that Amit Langote-san posed.

Agreed.
I summarized my test results for the current patch(V18) in the attached file(Please use VSCode or Notepad++ to open it, the context is a bit long).
As you can see, the performance is good in many patterns(Please refer to my test script, test NO in text is correspond to number in sql file).
If you have any question on my test, please feel free to ask.

Regards,
Tang

Attachment Content-Type Size
performance test result_20210226.txt text/plain 4.5 KB
performance_test.sql application/octet-stream 21.1 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2021-02-26 09:29:05 Re: NOT VALID for Unique Indexes
Previous Message Benoit Lobréau 2021-02-26 09:03:05 Re: archive_command / pg_stat_archiver & documentation