Re: PoC/WIP: Extended statistics on expressions

From:	Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>
To:	Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc:	pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: PoC/WIP: Extended statistics on expressions
Date:	2020-12-03 15:23:16
Message-ID:	087086de-1384-8374-4efc-2e7915071d5c@enterprisedb.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2020-11-16 13:49:42 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎  2020-11-16 15:27:46 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>   2020-11-22 19:03:51 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎    2020-11-23 02:26:04 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎     2020-11-23 03:30:26 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>      2020-11-23 23:30:18 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎       2020-12-03 15:23:16 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎        2020-12-07 09:56:00 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>         2020-12-07 14:15:17 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>          2020-12-07 16:02:00 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>           2020-12-08 12:44:10 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>            2020-12-11 12:58:36 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>             2020-12-11 20:17:40 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎              2021-01-04 15:34:08 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>               2021-01-04 15:45:24 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                2021-03-05 00:43:35 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                 2021-03-05 01:17:37 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>               2021-01-05 00:45:05 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                2021-01-05 14:10:08 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                 2021-01-05 15:09:19 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                  2021-01-06 15:11:20 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                   2021-01-07 13:49:50 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                    2021-01-08 00:57:29 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                     2021-01-08 02:35:37 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                      2021-01-09 00:04:35 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                       2021-01-16 16:48:43 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                        2021-01-16 23:22:08 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                         2021-01-17 00:23:39 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                          2021-01-17 02:55:20 from Zhihong Yu <zyu(at)yugabyte(dot)com>                           2021-01-17 23:14:30 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                          2021-01-17 05:29:54 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                           2021-01-17 23:26:17 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                          2021-01-18 04:53:31 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                           2021-01-18 15:48:28 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                            2021-01-19 01:57:05 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                             2021-01-21 11:11:55 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                              2021-01-22 01:26:29 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                               2021-01-22 02:29:58 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                2021-01-22 03:49:51 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                                 2021-01-22 04:01:01 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                  2021-01-22 04:46:07 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                   2021-01-22 09:00:40 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                                    2021-01-22 13:06:51 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                  2021-01-22 13:09:04 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                   2021-06-03 02:39:20 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                   2021-08-16 01:31:01 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                    2021-08-16 13:19:53 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                 2021-01-27 11:02:51 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> 📎                                  2021-02-16 18:40:29 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                   2021-02-18 01:31:44 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                                    2021-03-04 22:16:04 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                                     2021-03-05 14:32:29 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                                      2021-03-07 21:10:09 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                                       2021-03-17 15:55:41 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                                        2021-03-17 17:25:58 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                         2021-03-17 18:54:41 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                                          2021-03-17 19:07:22 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                           2021-03-17 20:48:51 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                                            2021-03-17 20:58:22 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                                             2021-03-17 21:30:59 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                              2021-03-18 07:54:38 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                                               2021-03-24 00:51:09 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                                                2021-03-24 06:24:47 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                 2021-03-24 16:38:32 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                 2021-03-24 16:42:26 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                2021-03-24 08:14:02 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                 2021-03-24 08:54:22 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                  2021-03-24 09:17:08 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                   2021-03-24 10:22:06 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                                                    2021-03-24 13:36:15 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> 📎                                                     2021-03-24 14:47:54 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                      2021-03-24 16:28:05 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                                                       2021-03-24 16:48:17 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                        2021-03-24 17:15:46 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                                                         2021-03-24 17:18:16 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                          2021-03-24 19:50:24 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                        2021-03-25 00:05:37 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                                                         2021-03-25 00:30:06 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                          2021-03-25 01:33:06 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                                                         2021-03-25 04:07:17 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                         2021-03-25 11:35:21 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                                                         2021-03-25 13:33:34 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                                                          2021-03-25 19:59:04 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                                                           2021-03-26 11:37:37 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                                                            2021-03-26 12:54:13 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                             2021-03-27 00:17:14 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                              2021-03-27 02:11:30 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                              2021-04-23 02:50:12 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                              2021-06-06 05:37:40 from Noah Misch <noah(at)leadboat(dot)com>                                                               2021-06-06 19:13:17 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                                2021-06-06 19:17:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                 2021-06-06 20:01:23 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                                  2021-06-06 20:08:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                2021-06-11 04:55:46 from Noah Misch <noah(at)leadboat(dot)com>                                                                 2021-06-11 11:04:36 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>          2021-08-16 01:32:55 from Justin Pryzby <pryzby(at)telsasoft(dot)com>           2021-08-16 15:41:57 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎            2021-08-18 03:07:54 from Justin Pryzby <pryzby(at)telsasoft(dot)com>             2021-08-18 11:43:54 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>            2021-08-24 13:13:20 from Justin Pryzby <pryzby(at)telsasoft(dot)com>             2021-09-01 16:45:29 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎              2021-09-01 19:38:16 from Justin Pryzby <pryzby(at)telsasoft(dot)com>               2021-09-01 19:56:20 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>              2021-09-03 03:56:01 from Justin Pryzby <pryzby(at)telsasoft(dot)com>               2021-09-19 23:07:23 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>      2020-11-24 16:23:20 from Justin Pryzby <pryzby(at)telsasoft(dot)com>       2020-11-24 17:29:05 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
0001-bootstrap-convert-Typ-to-a-List-20201203.patch	text/x-patch	3.7 KB
0002-Allow-composite-types-in-bootstrap-20201203.patch	text/x-patch	1.4 KB
0003-Extended-statistics-on-expressions-20201203.patch	text/x-patch	234.1 KB

In response to

• Re: PoC/WIP: Extended statistics on expressions at 2020-11-23 23:30:18 from Tomas Vondra

Responses

• Re: PoC/WIP: Extended statistics on expressions at 2020-12-07 09:56:00 from Dean Rasheed

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Tom Lane	2020-12-03 15:34:15	Re: SELECT INTO deprecation
Previous Message	Heikki Linnakangas	2020-12-03 15:15:46	Re: Corner-case bug in pg_rewind