Re: Eager aggregation, take 3

From:	Richard Guo <guofenglinux(at)gmail(dot)com>
To:	Andy Fan <zhihuifan1213(at)163(dot)com>
Cc:	PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject:	Re: Eager aggregation, take 3
Date:	2024-04-10 09:42:52
Message-ID:	CAMbWs49B_qUiHvu2EqLHZRpLr3p_+QPBs50n2=L5ibYzniwTzA@mail.gmail.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2024-03-04 08:27:24 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎  2024-03-04 11:45:43 from Andy Fan <zhihuifan1213(at)163(dot)com>   2024-03-05 06:47:27 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎    2024-03-05 11:19:41 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎     2024-03-21 10:51:55 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎      2024-04-10 09:42:52 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎       2024-04-30 04:06:42 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎        2024-05-20 08:12:49 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎         2024-06-13 08:07:51 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎          2024-07-03 08:29:27 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎           2024-07-07 02:45:32 from Paul George <p(dot)a(dot)george19(at)gmail(dot)com>            2024-07-10 08:27:02 from Richard Guo <guofenglinux(at)gmail(dot)com>             2024-07-11 21:50:35 from Paul George <p(dot)a(dot)george19(at)gmail(dot)com>              2024-08-16 08:14:41 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎               2024-08-21 07:10:51 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎                2024-08-23 15:59:17 from Robert Haas <robertmhaas(at)gmail(dot)com>                 2024-08-29 02:26:01 from Richard Guo <guofenglinux(at)gmail(dot)com>                  2024-08-29 12:40:09 from Robert Haas <robertmhaas(at)gmail(dot)com>                  2024-11-06 05:04:38 from jian he <jian(dot)universality(at)gmail(dot)com>                2024-08-28 03:57:12 from Tender Wang <tndrwang(at)gmail(dot)com>                 2024-08-28 13:00:57 from Robert Haas <robertmhaas(at)gmail(dot)com>                  2024-08-29 02:45:58 from Richard Guo <guofenglinux(at)gmail(dot)com>                   2024-08-29 03:22:24 from Tender Wang <tndrwang(at)gmail(dot)com>                   2024-08-29 03:38:11 from Tender Wang <tndrwang(at)gmail(dot)com>                    2024-08-29 13:02:10 from Robert Haas <robertmhaas(at)gmail(dot)com>                  2024-09-25 03:20:14 from Richard Guo <guofenglinux(at)gmail(dot)com>                   2024-09-27 03:53:43 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎                    2024-10-05 10:23:02 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎                     2024-10-06 03:29:58 from Richard Guo <guofenglinux(at)gmail(dot)com>                      2024-10-30 13:09:37 from Robert Haas <robertmhaas(at)gmail(dot)com>                     2024-10-18 03:44:42 from jian he <jian(dot)universality(at)gmail(dot)com>                      2024-10-18 13:22:00 from jian he <jian(dot)universality(at)gmail(dot)com>                       2024-10-29 07:56:56 from Richard Guo <guofenglinux(at)gmail(dot)com>                        2024-10-30 15:25:31 from Robert Haas <robertmhaas(at)gmail(dot)com>                         2024-11-01 06:21:06 from Richard Guo <guofenglinux(at)gmail(dot)com>                          2024-11-01 12:41:51 from Robert Haas <robertmhaas(at)gmail(dot)com>                           2024-11-06 08:21:54 from Richard Guo <guofenglinux(at)gmail(dot)com>                            2024-11-06 14:43:27 from Robert Haas <robertmhaas(at)gmail(dot)com>                             2024-11-11 00:51:51 from Richard Guo <guofenglinux(at)gmail(dot)com>                              2024-11-11 16:30:18 from Robert Haas <robertmhaas(at)gmail(dot)com>                               2024-11-12 00:27:24 from Richard Guo <guofenglinux(at)gmail(dot)com>                              2024-12-04 14:38:30 from Robert Haas <robertmhaas(at)gmail(dot)com>                               2024-12-17 00:56:13 from Richard Guo <guofenglinux(at)gmail(dot)com>                      2024-10-29 07:51:37 from Richard Guo <guofenglinux(at)gmail(dot)com>                       2024-10-30 15:30:57 from Robert Haas <robertmhaas(at)gmail(dot)com>                        2024-10-31 12:15:58 from jian he <jian(dot)universality(at)gmail(dot)com>                         2024-11-01 06:30:30 from Richard Guo <guofenglinux(at)gmail(dot)com>                   2024-10-29 20:05:50 from Robert Haas <robertmhaas(at)gmail(dot)com>                    2024-11-01 05:54:28 from Richard Guo <guofenglinux(at)gmail(dot)com>                     2024-12-17 03:42:28 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎                      2024-12-21 01:05:09 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎                       2025-01-09 03:15:09 from jian he <jian(dot)universality(at)gmail(dot)com>                        2025-01-09 09:27:06 from Richard Guo <guofenglinux(at)gmail(dot)com>                       2025-01-13 02:04:34 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎                        2025-01-14 15:07:14 from Robert Haas <robertmhaas(at)gmail(dot)com>                         2025-01-15 06:58:02 from Richard Guo <guofenglinux(at)gmail(dot)com>                          2025-01-15 14:40:42 from Robert Haas <robertmhaas(at)gmail(dot)com>                           2025-01-16 08:18:18 from Richard Guo <guofenglinux(at)gmail(dot)com>                            2025-01-16 21:40:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                             2025-01-17 12:19:43 from Richard Guo <guofenglinux(at)gmail(dot)com>                            2025-01-17 21:16:19 from Robert Haas <robertmhaas(at)gmail(dot)com>                             2025-01-19 12:53:05 from Richard Guo <guofenglinux(at)gmail(dot)com>                              2025-01-20 16:28:17 from Robert Haas <robertmhaas(at)gmail(dot)com>                               2025-01-20 17:57:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                2025-01-20 18:39:15 from Robert Haas <robertmhaas(at)gmail(dot)com>                                2025-01-21 14:13:14 from Richard Guo <guofenglinux(at)gmail(dot)com>                               2025-01-21 08:33:29 from Richard Guo <guofenglinux(at)gmail(dot)com>                                2025-01-21 16:36:16 from Robert Haas <robertmhaas(at)gmail(dot)com>                                 2025-01-22 06:48:43 from Richard Guo <guofenglinux(at)gmail(dot)com>                                  2025-01-24 20:53:42 from Robert Haas <robertmhaas(at)gmail(dot)com>                                   2025-06-13 07:41:57 from Richard Guo <guofenglinux(at)gmail(dot)com>                                    2025-06-26 02:01:35 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎                                     2025-07-24 03:21:30 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎                                      2025-08-06 07:52:36 from Richard Guo <guofenglinux(at)gmail(dot)com>                                       2025-08-06 13:44:29 from "Matheus Alcantara" <matheusssilv97(at)gmail(dot)com>                                        2025-08-09 01:32:21 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎                                         2025-08-14 19:22:49 from "Matheus Alcantara" <matheusssilv97(at)gmail(dot)com>                                          2025-08-15 01:41:18 from Richard Guo <guofenglinux(at)gmail(dot)com>                                         2025-09-01 01:32:33 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎                                          2025-09-05 07:35:17 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎                                           2025-09-05 14:37:10 from Robert Haas <robertmhaas(at)gmail(dot)com>                                            2025-09-09 10:30:04 from Richard Guo <guofenglinux(at)gmail(dot)com>                                             2025-09-09 14:30:01 from Robert Haas <robertmhaas(at)gmail(dot)com>                                       2025-09-05 13:12:44 from Robert Haas <robertmhaas(at)gmail(dot)com>                                        2025-09-09 09:20:21 from Richard Guo <guofenglinux(at)gmail(dot)com>                                         2025-09-09 14:20:14 from Robert Haas <robertmhaas(at)gmail(dot)com>                                          2025-09-12 09:34:43 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎                                           2025-09-12 18:47:48 from Robert Haas <robertmhaas(at)gmail(dot)com>                                            2025-09-13 08:27:41 from Richard Guo <guofenglinux(at)gmail(dot)com>                                             2025-09-25 04:23:00 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎                                              2025-09-29 02:09:07 from Richard Guo <guofenglinux(at)gmail(dot)com>                                               2025-10-01 23:54:32 from Matheus Alcantara <matheusssilv97(at)gmail(dot)com> 📎                                                2025-10-02 01:13:48 from Richard Guo <guofenglinux(at)gmail(dot)com>                                                 2025-10-02 01:39:50 from Richard Guo <guofenglinux(at)gmail(dot)com>                                                  2025-10-02 08:49:27 from Richard Guo <guofenglinux(at)gmail(dot)com>                                                   2025-10-02 18:40:47 from Matheus Alcantara <matheusssilv97(at)gmail(dot)com> 📎                                                    2025-10-03 03:14:40 from Richard Guo <guofenglinux(at)gmail(dot)com>                                                     2025-10-03 20:03:08 from "Matheus Alcantara" <matheusssilv97(at)gmail(dot)com> 📎                                                      2025-10-06 00:56:25 from Richard Guo <guofenglinux(at)gmail(dot)com>                                               2025-10-06 00:59:11 from Richard Guo <guofenglinux(at)gmail(dot)com>                                                2025-10-06 13:59:44 from David Rowley <dgrowleyml(at)gmail(dot)com>                                                 2025-10-07 10:56:48 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎                                                  2025-10-08 11:14:39 from David Rowley <dgrowleyml(at)gmail(dot)com>                                                   2025-10-09 01:49:48 from Richard Guo <guofenglinux(at)gmail(dot)com>                                                    2025-10-09 08:07:08 from Richard Guo <guofenglinux(at)gmail(dot)com>                                                  2025-10-08 14:45:12 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                   2025-10-09 01:51:03 from Richard Guo <guofenglinux(at)gmail(dot)com>                                                    2025-10-09 02:13:28 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                     2025-10-09 03:10:31 from Richard Guo <guofenglinux(at)gmail(dot)com>                                                2025-10-09 01:48:27 from Richard Guo <guofenglinux(at)gmail(dot)com>                                                 2025-10-09 05:09:00 from Antonin Houska <ah(at)cybertec(dot)at>                                                  2025-10-09 07:01:28 from Richard Guo <guofenglinux(at)gmail(dot)com>                                       2025-09-05 14:50:15 from Robert Haas <robertmhaas(at)gmail(dot)com>                                        2025-09-09 11:18:20 from Richard Guo <guofenglinux(at)gmail(dot)com>                                    2025-09-05 13:09:56 from Robert Haas <robertmhaas(at)gmail(dot)com>                                     2025-09-09 09:07:54 from Richard Guo <guofenglinux(at)gmail(dot)com>                 2024-08-29 02:29:26 from Richard Guo <guofenglinux(at)gmail(dot)com>                2024-09-04 03:48:30 from Tender Wang <tndrwang(at)gmail(dot)com>                 2024-09-13 07:48:20 from Tender Wang <tndrwang(at)gmail(dot)com>                  2024-09-25 07:12:57 from Richard Guo <guofenglinux(at)gmail(dot)com>                2024-09-05 01:40:18 from Tender Wang <tndrwang(at)gmail(dot)com>                 2024-09-25 06:55:00 from Richard Guo <guofenglinux(at)gmail(dot)com>                2024-09-11 02:52:05 from Tender Wang <tndrwang(at)gmail(dot)com>                 2024-09-25 07:02:51 from Richard Guo <guofenglinux(at)gmail(dot)com>                  2024-10-29 12:59:21 from Robert Haas <robertmhaas(at)gmail(dot)com>                   2024-11-01 01:50:24 from Richard Guo <guofenglinux(at)gmail(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v5-0001-Introduce-RelInfoList-structure.patch	application/octet-stream	14.3 KB
v5-0002-Introduce-RelAggInfo-structure-to-store-info-for-grouped-paths.patch	application/octet-stream	7.8 KB
v5-0003-Set-up-for-eager-aggregation-by-collecting-needed-infos.patch	application/octet-stream	14.3 KB
v5-0004-Implement-functions-that-create-RelAggInfos-if-applicable.patch	application/octet-stream	26.0 KB
v5-0005-Implement-functions-that-generate-paths-for-grouped-relations.patch	application/octet-stream	13.1 KB
v5-0006-Build-grouped-relations-out-of-base-relations.patch	application/octet-stream	9.0 KB
v5-0007-Build-grouped-relations-out-of-join-relations.patch	application/octet-stream	24.4 KB
v5-0008-Add-test-cases.patch	application/octet-stream	71.5 KB
v5-0009-Add-README.patch	application/octet-stream	4.8 KB

In response to

• Re: Eager aggregation, take 3 at 2024-03-21 10:51:55 from Richard Guo

Responses

• Re: Eager aggregation, take 3 at 2024-04-30 04:06:42 from Richard Guo

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Amit Kapila	2024-04-10 09:58:22	Re: Is this a problem in GenericXLogFinish()?
Previous Message	jian he	2024-04-10 09:34:30	Re: Can't find not null constraint, but \d+ shows that