Use COPY for populating all pgbench tables

4408

Title

Topic

Performance

Created

2023-06-27 14:26:27

Last modified

2023-07-24 05:02:56 (1 year, 3 months ago)

Latest email

2023-07-24 13:54:17 (1 year, 3 months ago)

Status

2023-07: Committed

Target version

Authors

Tristan Partin (tristan957)

Reviewers

Michael Paquier (michael-kun), Fabien Coelho (calvin)Become reviewer

Committer

Michael Paquier (michael-kun)

Links

CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/4408
git checkout commitfest/cf/4408

Emails

Use COPY for populating all pgbench tables: First at 2023-05-23 17:33:21 by "Tristan Partin" <tristan at neon.tech>
Latest at 2023-07-24 13:54:17 by "Tristan Partin" <tristan at neon.tech>
Latest attachment (v7-0001-Use-COPY-instead-of-INSERT-for-populating-all-tab.patch) at 2023-07-21 02:14:57 from Michael Paquier <michael at paquier.xyz>
    Attachment (v7-0001-Use-COPY-instead-of-INSERT-for-populating-all-tab.patch) at 2023-07-21 02:14:57 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (v6-0001-Use-COPY-instead-of-INSERT-for-populating-all-tab.patch) at 2023-07-20 19:22:51 from "Tristan Partin" <tristan at neon.tech> (Patch: Yes)
    Attachment (v5-0001-Use-COPY-instead-of-INSERT-for-populating-all-tab.patch) at 2023-07-19 18:03:21 from "Tristan Partin" <tristan at neon.tech> (Patch: Yes)
    Attachment (v4-0001-Use-COPY-instead-of-INSERT-for-populating-all-tab.patch) at 2023-07-19 18:01:29 from "Tristan Partin" <tristan at neon.tech> (Patch: Yes)
    Attachment (v3-0001-Use-COPY-instead-of-INSERT-for-populating-all-tab.patch) at 2023-07-11 14:46:43 from "Tristan Partin" <tristan at neon.tech> (Patch: Yes)
    Attachment (v2-0001-Move-constant-into-format-string.patch) at 2023-06-14 15:58:06 from "Tristan Partin" <tristan at neon.tech> (Patch: Yes)
    Attachment (samples.txt) at 2023-06-10 03:52:29 from Gurjeet Singh <gurjeet at singh.im> (Patch: No)
    Attachment (variant-2-detailed-description.patch) at 2023-06-10 01:20:12 from Gurjeet Singh <gurjeet at singh.im> (Patch: Yes)
    Attachment (pgbench_hex_copy.patch) at 2023-06-08 05:33:57 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Move-constant-into-format-string.patch) at 2023-05-23 17:33:21 from "Tristan Partin" <tristan at neon.tech> (Patch: Yes)

History

When	Who	What
2023-07-24 05:02:56	Michael Paquier (michael-kun)	Closed in commitfest 2023-07 with status: Committed
2023-07-24 05:02:56	Michael Paquier (michael-kun)	Changed committer to michael-kun
2023-07-11 05:14:03	Michael Paquier (michael-kun)	New status: Waiting on Author
2023-07-11 05:14:00	Michael Paquier (michael-kun)	Added michael-kun as reviewer
2023-07-07 06:30:22	Fabien Coelho (calvin)	Added calvin as reviewer
2023-06-27 14:26:37	Tristan Partin (tristan957)	Changed authors to Tristan Partin (tristan957)
2023-06-27 14:26:27	Tristan Partin (tristan957)	Attached mail thread CSTU5P82ONZ1.19XFUGHMXHBRY@c3po
2023-06-27 14:26:27	Tristan Partin (tristan957)	Created patch record