Re: Todo: Teach planner to evaluate multiple windows in the optimal order

From:	Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>
To:	David Rowley <dgrowleyml(at)gmail(dot)com>
Cc:	pghackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject:	Re: Todo: Teach planner to evaluate multiple windows in the optimal order
Date:	2023-01-04 15:11:27
Message-ID:	295d9e2c-ff3a-95f0-403c-7e0056093095@gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2022-12-25 13:04:38 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>  2023-01-03 02:51:36 from David Rowley <dgrowleyml(at)gmail(dot)com>   2023-01-03 07:09:41 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>   2023-01-03 14:11:28 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>    2023-01-04 04:02:15 from David Rowley <dgrowleyml(at)gmail(dot)com>     2023-01-04 12:07:46 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>      2023-01-04 15:11:27 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com> 📎       2023-01-07 02:29:55 from David Rowley <dgrowleyml(at)gmail(dot)com>        2023-01-07 11:14:40 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>      2023-01-05 02:18:24 from Vik Fearing <vik(at)postgresfriends(dot)org>       2023-01-04 15:30:50 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>        2023-01-05 07:23:40 from David Rowley <dgrowleyml(at)gmail(dot)com>         2023-01-05 07:46:15 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>          2023-01-06 13:11:33 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com> 📎           2023-01-07 04:28:28 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎            2023-01-07 11:10:05 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>             2023-01-07 11:58:03 from David Rowley <dgrowleyml(at)gmail(dot)com>              2023-01-07 12:51:58 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>               2023-01-07 22:05:15 from David Rowley <dgrowleyml(at)gmail(dot)com>            2023-01-07 16:27:07 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>             2023-01-07 16:45:49 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com> 📎              2023-01-07 22:36:58 from David Rowley <dgrowleyml(at)gmail(dot)com>               2023-01-08 06:29:27 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>             2023-01-07 22:26:08 from David Rowley <dgrowleyml(at)gmail(dot)com>              2023-01-08 06:18:05 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>               2023-01-08 10:21:35 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com> 📎                2023-01-08 11:03:54 from David Rowley <dgrowleyml(at)gmail(dot)com>                 2023-01-08 17:17:19 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com> 📎                  2023-01-08 22:18:58 from David Rowley <dgrowleyml(at)gmail(dot)com>                   2023-01-09 08:34:08 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com> 📎                    2023-01-09 12:23:14 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                     2023-01-09 17:15:12 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com> 📎                      2023-01-10 05:23:50 from David Rowley <dgrowleyml(at)gmail(dot)com>                       2023-01-10 05:36:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                        2023-01-11 00:54:04 from David Rowley <dgrowleyml(at)gmail(dot)com>                       2023-01-10 08:31:52 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>                       2023-01-10 19:17:25 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>                        2023-01-11 00:48:16 from David Rowley <dgrowleyml(at)gmail(dot)com>                         2023-01-11 06:21:06 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>                          2023-01-13 02:18:20 from David Rowley <dgrowleyml(at)gmail(dot)com>                           2023-01-13 05:36:19 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>                           2023-01-15 17:52:47 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com> 📎                            2023-01-16 04:18:32 from David Rowley <dgrowleyml(at)gmail(dot)com>                             2023-01-16 06:08:45 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>                      2023-01-18 09:42:40 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                       2023-01-18 17:27:09 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>                        2023-01-19 03:28:01 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                         2023-01-19 05:22:00 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>                          2023-01-24 17:32:18 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>                           2023-01-26 02:10:44 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                            2023-01-28 08:21:09 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>                             2023-01-28 09:01:35 from John Naylor <john(dot)naylor(at)enterprisedb(dot)com>                              2023-01-28 10:49:59 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>                            2023-01-29 12:05:15 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com> 📎                             2023-01-30 05:31:47 from John Naylor <john(dot)naylor(at)enterprisedb(dot)com>                              2023-01-30 09:32:37 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>                            2023-02-14 04:21:43 from John Naylor <john(dot)naylor(at)enterprisedb(dot)com> 📎                             2023-02-14 10:45:53 from David Rowley <dgrowleyml(at)gmail(dot)com>                              2023-02-15 04:23:15 from John Naylor <john(dot)naylor(at)enterprisedb(dot)com> 📎                               2023-02-15 08:02:31 from David Rowley <dgrowleyml(at)gmail(dot)com>                                2023-02-15 11:45:01 from John Naylor <john(dot)naylor(at)enterprisedb(dot)com> 📎                                 2023-02-16 03:02:44 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                                  2023-02-16 11:28:23 from John Naylor <john(dot)naylor(at)enterprisedb(dot)com>                               2023-06-30 06:45:32 from John Naylor <john(dot)naylor(at)enterprisedb(dot)com> 📎                                2023-07-03 10:14:50 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                                 2023-08-16 10:24:33 from John Naylor <john(dot)naylor(at)enterprisedb(dot)com>                             2023-02-15 08:03:22 from John Naylor <john(dot)naylor(at)enterprisedb(dot)com> 📎                2023-01-08 16:06:13 from Vik Fearing <vik(at)postgresfriends(dot)org>                 2023-01-08 17:05:08 from Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>                  2023-01-08 19:21:03 from Vik Fearing <vik(at)postgresfriends(dot)org>                 2023-01-08 20:52:07 from David Rowley <dgrowleyml(at)gmail(dot)com>       2023-01-05 02:30:59 from David Rowley <dgrowleyml(at)gmail(dot)com>        2023-01-05 03:12:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>         2023-01-05 07:14:49 from David Rowley <dgrowleyml(at)gmail(dot)com>       2023-01-05 02:48:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v1-0001-add-test-cases-for-optimal-ordering-of-window-functi.patch	text/x-patch	7.8 KB

In response to

• Re: Todo: Teach planner to evaluate multiple windows in the optimal order at 2023-01-04 12:07:46 from Ankit Kumar Pandey

Responses

• Re: Todo: Teach planner to evaluate multiple windows in the optimal order at 2023-01-07 02:29:55 from David Rowley

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Daniel Verite	2023-01-04 15:22:03	Re: psql's FETCH_COUNT (cursor) is not being respected for CTEs
Previous Message	Ibrar Ahmed	2023-01-04 15:04:53	Re: explain analyze rows=%.0f