Use optimized single-datum tuplesort in ExecSort

3237

Title

Topic

Performance

Created

2021-07-06 06:17:30

Last modified

2021-07-22 04:38:25 (3 years, 3 months ago)

Latest email

2021-07-22 02:04:04 (3 years, 3 months ago)

Status

2021-09: Committed

Target version

Authors

Ronan Dunklau (rdunklau)

Reviewers

James Coleman (jcole1989), Ranier Vilela (raniervilela)Become reviewer

Committer

David Rowley (davidrowley)

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/3237
git checkout commitfest/cf/3237

Emails

[PATCH] Use optimized single-datum tuplesort in ExecSort: First at 2021-07-06 06:15:41 by Ronan Dunklau <ronan.dunklau at aiven.io>
Latest at 2021-07-22 02:04:04 by David Rowley <dgrowleyml at gmail.com>
Latest attachment (v10-0001-Make-nodeSort.c-do-Datum-sorts-for-single-column.patch) at 2021-07-21 01:07:35 from David Rowley <dgrowleyml at gmail.com>
    Attachment (v10-0001-Make-nodeSort.c-do-Datum-sorts-for-single-column.patch) at 2021-07-21 01:07:35 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (costsize.patch) at 2021-07-20 11:28:35 from Ranier Vilela <ranier.vf at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Make-nodeSort.c-do-Datum-sorts-for-single-column.patch) at 2021-07-16 03:44:49 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Allow-Sort-nodes-to-use-the-fast-single-datum-tuples.patch) at 2021-07-15 14:53:29 from Ronan Dunklau <ronan.dunklau at aiven.io> (Patch: Yes)
    Attachment (results.csv) at 2021-07-15 10:18:22 from Ronan Dunklau <ronan.dunklau at aiven.io> (Patch: No)
    Attachment (bench_datumsort_high.txt) at 2021-07-15 02:55:04 from Ranier Vilela <ranier.vf at gmail.com> (Patch: No)
    Attachment (datum-sort-test-JCN-1.txt) at 2021-07-14 23:30:26 from John Naylor <john.naylor at enterprisedb.com> (Patch: No)
    Attachment (bench_datumsort_v8.txt) at 2021-07-14 17:55:13 from Ranier Vilela <ranier.vf at gmail.com> (Patch: No)
    Attachment (v8_poc_datum_tuple_sort.patch) at 2021-07-14 10:13:45 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (bench_datumsort.txt) at 2021-07-13 17:42:13 from Ranier Vilela <ranier.vf at gmail.com> (Patch: No)
    Attachment (allow_single_datum_sort.patch) at 2021-07-13 12:44:03 from Ranier Vilela <ranier.vf at gmail.com> (Patch: Yes)
    Attachment (Master @e0271d5f VS rebased V6 patch.png) at 2021-07-13 07:19:37 from Ronan Dunklau <ronan.dunklau at aiven.io> (Patch: No)
    Attachment (sortbench.sh.txt) at 2021-07-13 03:15:24 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (v5-0001-Allow-Sort-nodes-to-use-the-fast-single-datum-tuples.patch) at 2021-07-12 13:59:42 from Ronan Dunklau <ronan.dunklau at aiven.io> (Patch: Yes)
    Attachment (v4-0001-Allow-Sort-nodes-to-use-the-fast-single-datum-tuples.patch) at 2021-07-07 09:32:03 from Ronan Dunklau <ronan.dunklau at aiven.io> (Patch: Yes)
    Attachment (v3-0001-Allow-Sort-nodes-to-use-the-fast-single-datum-tuples.patch) at 2021-07-06 15:03:32 from Ronan Dunklau <ronan.dunklau at aiven.io> (Patch: Yes)
    Attachment (v2-0001-Allow-Sort-nodes-to-use-the-fast-single-datum-tuples.patch) at 2021-07-06 06:15:41 from Ronan Dunklau <ronan.dunklau at aiven.io> (Patch: Yes)

History

When	Who	What
2021-07-22 04:38:25	David Rowley (davidrowley)	Closed in commitfest 2021-09 with status: Committed
2021-07-22 04:38:13	David Rowley (davidrowley)	Added davidrowley as committer
2021-07-06 06:18:23	Ronan Dunklau (rdunklau)	Changed reviewers to James Coleman (jcole1989), Ranier Vilela (raniervilela)
2021-07-06 06:18:23	Ronan Dunklau (rdunklau)	Changed authors to Ronan Dunklau (rdunklau)
2021-07-06 06:18:23	Ronan Dunklau (rdunklau)	Changed targetversion to 15
2021-07-06 06:17:30	Ronan Dunklau (rdunklau)	Attached mail thread 3177670.itZtoPt7T5@aivenronan
2021-07-06 06:17:30	Ronan Dunklau (rdunklau)	Created patch record