Split out tiebreaker comparisons from comparetup_* functions

Edit
Title Split out tiebreaker comparisons from comparetup_* functions
Topic Performance
Created 2023-06-30 06:47:36
Last modified 2023-08-22 03:22:00 (11 months ago)
Latest email 2023-08-16 10:24:33 (11 months ago)
Status
2023-09: Committed
2023-07: Moved to next CF
Target version
Authors John Naylor (john.naylor)
Reviewers Become reviewer
Committer John Naylor (john.naylor)
Links
Emails
Todo: Teach planner to evaluate multiple windows in the optimal order
First at 2022-12-25 13:04:38 by Ankit Kumar Pandey <itsankitkp at gmail.com>
Latest at 2023-08-16 10:24:33 by John Naylor <john.naylor at enterprisedb.com>
Latest attachment (window_sort_speedup_1m.png) at 2023-07-03 10:14:50 from David Rowley <dgrowleyml at gmail.com>
    Attachment (window_sort_speedup_1m.png) at 2023-07-03 10:14:50 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (v3-0001-Split-out-tiebreaker-comparisons-from-comparetup_.patch) at 2023-06-30 06:45:32 from John Naylor <john.naylor at enterprisedb.com> (Patch: Yes)
    Attachment (tuplesort_cache_aware_hacks.patch) at 2023-02-16 03:02:44 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (bench_windowsort_workmem-20230215.sh) at 2023-02-15 11:45:01 from John Naylor <john.naylor at enterprisedb.com> (Patch: No)
    Attachment (window-sort-jcn-random-10e6-20230215.png) at 2023-02-15 08:03:22 from John Naylor <john.naylor at enterprisedb.com> (Patch: No)
    Attachment (bench_cartesiansort.sh) at 2023-02-15 04:23:15 from John Naylor <john.naylor at enterprisedb.com> (Patch: No)
    Attachment (v2-0001-Split-out-fallback-functionality-from-comparetup-.patch.txt) at 2023-02-14 04:21:43 from John Naylor <john.naylor at enterprisedb.com> (Patch: Yes)
    Attachment (10 Million row test.png) at 2023-01-29 12:05:15 from Ankit Kumar Pandey <itsankitkp at gmail.com> (Patch: No)
    Attachment (bench_windowsort.sh.txt) at 2023-01-26 02:10:44 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (sort_hacks.diff) at 2023-01-19 03:28:01 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (better_windowclause_sorting_dgr-v9.patch) at 2023-01-18 09:42:40 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (better_windowclause_sorting_dgr-v8.patch) at 2023-01-15 17:52:47 from Ankit Kumar Pandey <itsankitkp at gmail.com> (Patch: Yes)
    Attachment (better_windowclause_sorting_dgr-v7.patch) at 2023-01-09 17:15:12 from Ankit Kumar Pandey <itsankitkp at gmail.com> (Patch: Yes)
    Attachment (better_windowclause_sorting_dgr-v6.patch) at 2023-01-09 12:23:14 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (better_windowclause_sorting_dgr-v5.patch) at 2023-01-09 08:34:08 from Ankit Kumar Pandey <itsankitkp at gmail.com> (Patch: Yes)
    Attachment (better_windowclause_sorting_dgr-v4.patch) at 2023-01-08 17:17:19 from Ankit Kumar Pandey <itsankitkp at gmail.com> (Patch: Yes)
    Attachment (better_windowclause_sorting_dgr-v3.patch) at 2023-01-08 10:21:35 from Ankit Kumar Pandey <itsankitkp at gmail.com> (Patch: Yes)
    Attachment (better_windowclause_sorting_dgr-v2.patch) at 2023-01-07 16:45:49 from Ankit Kumar Pandey <itsankitkp at gmail.com> (Patch: Yes)
    Attachment (better_windowclause_sorting_dgr.patch) at 2023-01-07 04:28:28 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v1-0002-Teach-planner-to-optimize-sorting-operations-for-win.patch) at 2023-01-06 13:11:33 from Ankit Kumar Pandey <itsankitkp at gmail.com> (Patch: Yes)
    Attachment (v1-0001-add-test-cases-for-optimal-ordering-of-window-functi.patch) at 2023-01-04 15:11:27 from Ankit Kumar Pandey <itsankitkp at gmail.com> (Patch: Yes)
History
When Who What
2023-08-22 03:22:00 John Naylor (john.naylor) Closed in commitfest 2023-09 with status: Committed
2023-08-15 09:53:47 John Naylor (john.naylor) Added john.naylor as committer
2023-08-15 09:53:44 John Naylor (john.naylor) New status: Ready for Committer
2023-08-01 21:06:38 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2023-07 with status: Moved to next CF
2023-06-30 06:48:01 John Naylor (john.naylor) Changed authors to John Naylor (john.naylor)
2023-06-30 06:47:36 John Naylor (john.naylor) Attached mail thread 83d80853-a45c-d85c-68eb-59acfe7fb5fb@gmail.com
2023-06-30 06:47:36 John Naylor (john.naylor) Created patch record
Edit