iframe-proxy | Sunbelt Computer Software

ID

4562

Title

GROUP BY optimization

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Tags

Performance

Created

2023-09-13 05:26:57

Last modified

2024-01-26 14:37:36 (2Â yearsÂ ago)

Latest email

2024-01-26 15:41:05 (2Â yearsÂ ago)

Status

2024-01 (2024-01-01 â€“ 2024-01-31): Committed

2023-11 (2023-11-01 â€“ 2023-12-04): Moved to different CF

Target version

Authors

Fedor Sigaev (sigaev), Tomas Vondra (fuzzycz), Andrei Lepikhov (lepikhov)

Reviewers

Become reviewer

Committer

Alexander Korotkov (smagen)

Links

Emails

POC: GROUP BY optimization: First at 2018-05-29 23:07:50 by Teodor Sigaev <teodor at sigaev.ru>
Latest at 2024-01-26 15:41:05 by Robert Haas <robertmhaas at gmail.com>
Latest attachment (0002-Explore-alternative-orderings-of-group-by-p-20240119.patch) at 2024-01-19 14:21:48 from Alexander Korotkov <aekorotkov at gmail.com>
Attachment (0002-Explore-alternative-orderings-of-group-by-p-20240119.patch) at 2024-01-19 14:21:48 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
Attachment (step2.txt) at 2024-01-18 14:18:34 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
Attachment (step1.txt) at 2024-01-18 09:48:54 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
Attachment (0001-Generalize-common-code-of-adding-sort-befor-20240116.patch) at 2024-01-16 15:05:33 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
Attachment (group_by.diff) at 2024-01-15 13:21:05 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
Attachment (0002-Explore-alternative-orderings-of-group-by-p-20240115.patch) at 2024-01-15 00:19:41 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
Attachment (details-2.txt) at 2024-01-14 12:14:13 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
Attachment (0001-Generalize-common-code-of-adding-sort-befor-20240113.patch) at 2024-01-13 15:00:03 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
Attachment (details.txt) at 2024-01-13 09:08:59 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
Attachment (0001-Generalize-common-code-of-adding-sort-befor-20240111.patch) at 2024-01-11 11:30:29 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
Attachment (0002-Explore-alternative-orderings-of-group-by-pathkeys-d-20240109.patch) at 2024-01-09 11:07:19 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
Attachment (0001-Generalize-common-code-of-adding-sort-before-generat.patch) at 2024-01-09 09:01:43 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
Attachment (0001-Explore-alternative-orderings-of-group-by-pathkeys-d-20231228.patch) at 2023-12-28 08:22:47 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
Attachment (0001-Explore-alternative-orderings-of-group-by-pathkeys-d-20231001.patch) at 2023-10-01 06:32:23 from Andrei Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
Attachment (0001-When-evaluating-a-query-with-a-multi-column-GROUP-BY-20230913.patch) at 2023-09-13 05:21:32 from Andrey Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
Attachment (0001-When-evaluating-a-query-with-a-multi-column-GROUP-BY-20230720.patch) at 2023-07-20 06:37:24 from Andrey Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
Attachment (fix_partitionwise_aggregate_test_master.patch) at 2022-08-18 01:32:14 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
Attachment (plans-14.log) at 2022-08-17 14:46:16 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: No)
Attachment (0001-Optimize-order-of-GROUP-BY-keys-20220329.patch) at 2022-03-29 18:00:29 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
Attachment (0001-Optimize-order-of-GROUP-BY-keys-20220328.patch) at 2022-03-29 00:48:50 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
Attachment (0001-Optimize-order-of-GROUP-BY-keys-20220315.patch) at 2022-03-15 08:26:47 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
Attachment (0002-Use-default-restriction-for-number-of-groups.txt) at 2022-02-10 09:00:37 from "Andrey V. Lepikhov" <a.lepikhov at postgrespro.ru> (Patch: Yes)
Attachment (bounded_heap_sort_fix.txt) at 2022-02-01 09:48:11 from "Andrey V. Lepikhov" <a.lepikhov at postgrespro.ru> (Patch: Yes)
Attachment (v20220121-0001-GROUP-BY-reordering.patch) at 2022-01-21 20:34:43 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
Attachment (guard_tuplesPerPrevGroup.txt) at 2022-01-21 11:09:01 from Andrey Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
Attachment (fixes.txt) at 2022-01-20 05:05:57 from "Andrey V. Lepikhov" <a.lepikhov at postgrespro.ru> (Patch: Yes)
Attachment (group-by-reorder-20210722.patch) at 2021-07-21 22:58:44 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
Attachment (group-by-reorder-20210720.patch) at 2021-07-20 13:12:38 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
Attachment (0001-v12-20210309.patch) at 2021-03-09 23:05:55 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
Attachment (v12-0001-GROUP-BY-optimization-made-compatible-with-chang.patch) at 2021-03-05 11:37:30 from Ibrar Ahmed <ibrar.ahmad at gmail.com> (Patch: Yes)
Attachment (v11-0001-GROUP-BY-optimization-made-compatible-with-chang.patch) at 2020-10-26 08:44:58 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)
Attachment (wip-group-by-incremental-sort-v1.patch) at 2020-05-16 14:56:09 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
Attachment (v12-0001-Add-tests-for-group-by-optimization.patch) at 2019-05-03 20:28:21 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
Attachment (v11-0001-Add-tests-for-group-by-optimization.patch) at 2019-04-04 15:11:09 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
Attachment (0002-opt_group_by_index_and_order-v10.patch) at 2018-06-13 16:41:20 from Teodor Sigaev <teodor at sigaev.ru> (Patch: Yes)
Attachment (0001-opt_group_by_index-v9.patch) at 2018-06-07 16:22:13 from Teodor Sigaev <teodor at sigaev.ru> (Patch: Yes)
Attachment (0001-opt_group_by_index-v8.patch) at 2018-06-06 18:04:09 from Teodor Sigaev <teodor at sigaev.ru> (Patch: Yes)
Attachment (0002-opt_group_by_index_and_order-v7.patch) at 2018-06-05 17:56:19 from Teodor Sigaev <teodor at sigaev.ru> (Patch: Yes)
Attachment (opt_group_by-v6.patch) at 2018-05-30 16:17:42 from Teodor Sigaev <teodor at sigaev.ru> (Patch: Yes)
Attachment (opt_group_by-v5.patch) at 2018-05-29 23:07:50 from Teodor Sigaev <teodor at sigaev.ru> (Patch: Yes)

History

Sunbelt Computer Software

PL/B Language Development and Support

GROUP BY optimization

Open statuses

Closed statuses

Move to

Open statuses

Closed statuses

Move to