Re: [HACKERS] Cached plans and statement generalization

From:	Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To:	Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>
Cc:	Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: [HACKERS] Cached plans and statement generalization
Date:	2019-09-25 20:06:11
Message-ID:	20190925200611.GA22668@alvherre.pgsql
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2017-04-24 08:46:02 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>  2017-04-24 10:24:23 from Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>   2017-04-24 11:04:42 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>  2017-04-24 18:43:53 from Andres Freund <andres(at)anarazel(dot)de>   2017-04-25 15:11:09 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎    2017-04-25 16:12:41 from Serge Rielau <serge(at)rielau(dot)com>     2017-04-25 16:45:20 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>      2017-04-25 17:09:37 from Serge Rielau <serge(at)rielau(dot)com>       2017-04-25 20:37:37 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>        2017-04-25 20:40:10 from Serge Rielau <serge(at)rielau(dot)com>         2017-04-25 20:47:44 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>          2017-04-25 21:11:08 from Doug Doole <ddoole(at)salesforce(dot)com>           2017-04-25 21:47:46 from Andres Freund <andres(at)anarazel(dot)de>            2017-04-25 22:21:22 from Doug Doole <ddoole(at)salesforce(dot)com>             2017-04-25 22:34:48 from Andres Freund <andres(at)anarazel(dot)de>              2017-04-25 22:48:16 from Doug Doole <ddoole(at)salesforce(dot)com>               2017-04-25 23:06:47 from Serge Rielau <serge(at)rielau(dot)com>               2017-04-26 17:08:18 from Doug Doole <ddoole(at)salesforce(dot)com>                2017-04-26 19:35:21 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>              2017-04-25 22:57:15 from "Finnerty, Jim" <jfinnert(at)amazon(dot)com>              2017-04-26 07:39:05 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>            2017-04-26 07:00:17 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>    2017-04-25 16:54:21 from David Fetter <david(at)fetter(dot)org>     2017-04-25 20:35:21 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>      2017-04-25 22:24:08 from David Fetter <david(at)fetter(dot)org>       2017-04-25 22:38:23 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>    2017-04-26 01:00:42 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>     2017-04-26 07:49:18 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>      2017-04-26 10:30:25 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎       2017-04-26 10:46:12 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>        2017-04-28 10:01:31 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎         2017-05-01 15:52:37 from Robert Haas <robertmhaas(at)gmail(dot)com>          2017-05-02 09:50:17 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>           2017-05-02 18:26:05 from Robert Haas <robertmhaas(at)gmail(dot)com>            2017-05-10 16:11:07 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎             2017-05-11 15:12:33 from Bruce Momjian <bruce(at)momjian(dot)us>              2017-05-11 17:39:58 from Douglas Doole <dougdoole(at)gmail(dot)com>               2017-05-11 18:15:05 from Bruce Momjian <bruce(at)momjian(dot)us>                2017-05-11 18:31:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2017-05-11 18:32:26 from Andres Freund <andres(at)anarazel(dot)de>                 2017-05-11 19:48:26 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>                  2017-05-11 19:52:26 from Andres Freund <andres(at)anarazel(dot)de>                   2017-05-11 20:30:46 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎              2017-05-11 19:41:45 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>               2017-05-12 00:58:15 from Bruce Momjian <bruce(at)momjian(dot)us>                2017-05-12 07:50:41 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>                 2017-05-12 15:23:18 from Bruce Momjian <bruce(at)momjian(dot)us>                  2017-05-12 17:35:26 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>                   2017-05-12 17:43:44 from Bruce Momjian <bruce(at)momjian(dot)us>                 2017-05-12 17:38:26 from Andres Freund <andres(at)anarazel(dot)de>             2017-05-15 15:31:46 from Robert Haas <robertmhaas(at)gmail(dot)com>              2017-05-18 08:57:57 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>               2017-05-18 16:47:17 from Andres Freund <andres(at)anarazel(dot)de>             2017-05-25 15:54:45 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎              2017-09-09 03:35:40 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>               2017-09-11 09:24:45 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎                2017-09-12 17:11:27 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎                 2017-11-30 01:59:12 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                  2017-11-30 02:07:11 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                   2017-11-30 02:10:26 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                  2017-12-04 15:46:07 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎                   2018-01-06 22:51:18 from Stephen Frost <sfrost(at)snowman(dot)net>                    2018-01-12 00:40:57 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>                     2018-01-12 12:53:11 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎                      2018-03-02 14:26:25 from David Steele <david(at)pgmasters(dot)net>                       2018-03-06 15:07:39 from David Steele <david(at)pgmasters(dot)net>                      2018-07-31 09:12:21 from "Yamaji, Ryo" <yamaji(dot)ryo(at)jp(dot)fujitsu(dot)com>                       2018-07-31 21:30:27 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>                        2018-08-01 07:32:14 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎                       2018-08-01 07:53:03 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>                        2018-08-02 05:25:53 from "Yamaji, Ryo" <yamaji(dot)ryo(at)jp(dot)fujitsu(dot)com>                         2018-08-02 22:02:19 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎                          2018-08-07 10:02:20 from "Yamaji, Ryo" <yamaji(dot)ryo(at)jp(dot)fujitsu(dot)com>                           2018-08-07 12:36:16 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>                            2018-08-22 04:54:18 from "Yamaji, Ryo" <yamaji(dot)ryo(at)jp(dot)fujitsu(dot)com>                             2018-08-24 15:36:52 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎                            2018-09-28 08:45:22 from "Yamaji, Ryo" <yamaji(dot)ryo(at)jp(dot)fujitsu(dot)com>                             2018-11-29 15:47:47 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                              2018-11-30 02:06:12 from "Yamaji, Ryo" <yamaji(dot)ryo(at)jp(dot)fujitsu(dot)com>                               2018-11-30 09:57:34 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                2019-01-29 01:38:46 from "Nagaura, Ryohei" <nagaura(dot)ryohei(at)jp(dot)fujitsu(dot)com>                                 2019-01-29 10:45:35 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎                                  2019-01-30 03:04:13 from "Nagaura, Ryohei" <nagaura(dot)ryohei(at)jp(dot)fujitsu(dot)com>                                  2019-03-19 02:56:38 from "Yamaji, Ryo" <yamaji(dot)ryo(at)jp(dot)fujitsu(dot)com>                                   2019-03-19 15:03:21 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎                                    2019-04-03 11:36:22 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎                                     2019-04-09 12:52:13 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎                                      2019-07-01 09:51:38 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                       2019-07-01 15:29:25 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎                                        2019-07-07 23:23:39 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                         2019-07-08 19:32:38 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>                                          2019-07-09 12:16:49 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                           2019-07-09 20:59:11 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎                                            2019-07-31 16:56:55 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>                                             2019-07-31 19:48:16 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>                                             2019-08-01 16:56:53 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎                                              2019-08-02 08:25:30 from Daniel Migowski <dmigowski(at)ikoffice(dot)de>                                               2019-08-02 08:57:31 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>                                                2019-08-02 09:01:47 from Daniel Migowski <dmigowski(at)ikoffice(dot)de>                                              2019-08-05 17:02:09 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎                                               2019-09-25 20:06:11 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                2019-09-26 07:23:38 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎                                                 2019-12-01 03:26:03 from Michael Paquier <michael(at)paquier(dot)xyz>                                                  2019-12-02 10:07:51 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎                                                   2020-03-01 19:26:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                    2020-07-01 09:18:52 from Daniel Gustafsson <daniel(at)yesql(dot)se>                                                    2021-04-25 18:57:10 from Юрий Соколов <funny(dot)falcon(at)gmail(dot)com>
Lists:	pgsql-hackers

In response to

• Re: [HACKERS] Cached plans and statement generalization at 2019-08-05 17:02:09 from Konstantin Knizhnik

Responses

• Re: [HACKERS] Cached plans and statement generalization at 2019-09-26 07:23:38 from Konstantin Knizhnik

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Andres Freund	2019-09-25 20:06:22	Re: Don't codegen deform code for virtual tuples in expr eval for scan fetch
Previous Message	Alvaro Herrera	2019-09-25 20:04:57	Re: [Patch] Add a reset_computed_values function in pg_stat_statements