Autoprepare: implicitly replace literals with parameters and store generalized plan

Edit

Title

Topic

Performance

Created

2018-08-07 12:21:45

Last modified

2020-07-01 09:19:06 (3 years, 10 months ago)

Latest email

2020-07-01 09:18:52 (3 years, 10 months ago)

Status

2020-07: Returned with feedback

2020-03: Moved to next CF

2020-01: Moved to next CF

2019-11: Moved to next CF

2019-09: Moved to next CF

2019-07: Moved to next CF

2019-03: Moved to next CF

2019-01: Moved to next CF

2018-11: Moved to next CF

2018-09: Moved to next CF

Target version

Authors

Konstantin Knizhnik (knizhnik)

Reviewers

Ryo Yamaji (ryamaji), Ryohei Nagaura (nyannyan)Become reviewer

Committer

Links

Emails

Cached plans and statement generalization: First at 2017-04-24 08:46:02 by Konstantin Knizhnik <k.knizhnik at postgrespro.ru>
Latest at 2020-07-01 09:18:52 by Daniel Gustafsson <daniel at yesql.se>
Latest attachment (autoprepare-extended-4.patch) at 2019-12-02 10:07:51 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru>
    Attachment (autoprepare-extended-4.patch) at 2019-12-02 10:07:51 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (autoprepare-extended-3.patch) at 2019-09-26 07:23:38 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (autoprepare-extended-2.patch) at 2019-08-05 17:02:09 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (autoprepare-extended-1.patch) at 2019-08-01 16:56:53 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (autoprepare-17.patch) at 2019-07-09 20:59:11 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (autoprepare-16.patch) at 2019-07-01 15:29:25 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (autoprepare-15.patch) at 2019-04-09 12:52:13 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (autoprepare-14.patch) at 2019-04-03 11:36:22 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (autoprepare-13.patch) at 2019-03-19 15:03:21 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (autoprepare-12.patch) at 2019-01-29 10:45:35 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (autoprepare-11.patch) at 2018-08-24 15:36:52 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (autoprepare-10.patch) at 2018-08-02 22:02:19 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (autoprepare-9.patch) at 2018-08-01 07:32:14 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (autoprepare-6.patch) at 2018-01-12 12:53:11 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (autoprepare-5.patch) at 2017-12-04 15:46:07 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (autoprepare-4.patch) at 2017-09-12 17:11:27 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (autoprepare-3.patch) at 2017-09-11 09:24:45 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (autoprepare.patch) at 2017-05-25 15:54:45 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (pgbench.svg) at 2017-05-11 20:30:46 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: No)
    Attachment (autoprepare-1.patch) at 2017-05-10 16:11:07 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (autoprepare.patch) at 2017-04-28 10:01:31 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (autoprepare.patch) at 2017-04-26 10:30:25 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (autoprepare.patch) at 2017-04-25 15:11:09 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)

History

When	Who	What
2020-07-01 09:19:06	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2020-07 with status: Returned with feedback
2020-04-08 16:07:18	David Steele (dsteele)	Changed targetversion to None
2020-04-08 15:30:00	David Steele (dsteele)	Closed in commitfest 2020-03 with status: Moved to next CF
2020-02-01 11:39:05	Tomas Vondra (fuzzycz)	Closed in commitfest 2020-01 with status: Moved to next CF
2020-02-01 11:39:00	Tomas Vondra (fuzzycz)	New status: Needs review
2019-12-01 03:26:19	Michael Paquier (michael-kun)	New status: Waiting on Author
2019-12-01 03:26:08	Michael Paquier (michael-kun)	Closed in commitfest 2019-11 with status: Moved to next CF
2019-09-30 18:55:34	Álvaro Herrera (alvherre)	Closed in commitfest 2019-09 with status: Moved to next CF
2019-08-01 22:24:05	Thomas Munro (macdice)	Closed in commitfest 2019-07 with status: Moved to next CF
2019-04-06 20:38:01	David Steele (dsteele)	Closed in commitfest 2019-03 with status: Moved to next CF
2019-02-07 04:31:00	Andres Freund (andresfreund)	Changed targetversion to 13
2019-02-04 05:33:42	Michael Paquier (michael-kun)	Closed in commitfest 2019-01 with status: Moved to next CF
2019-01-09 07:05:58	Ryohei Nagaura (nyannyan)	Added nyannyan as reviewer
2018-11-29 15:45:29	Dmitry Dolgov (erthalion)	Closed in commitfest 2018-11 with status: Moved to next CF
2018-11-16 19:08:24	Tom Lane (tgl)	Changed authors to Konstantin Knizhnik (knizhnik)
2018-10-02 02:14:19	Michael Paquier (michael-kun)	Closed in commitfest 2018-09 with status: Moved to next CF
2018-08-08 06:45:59	Ryo Yamaji (ryamaji)	Added ryamaji as reviewer
2018-08-07 12:21:45	Konstantin Knizhnik (knizhnik)	Attached mail thread 8e76d8fc-8b8c-14bd-d4d1-e9cf193a74f5@postgrespro.ru
2018-08-07 12:21:45	Konstantin Knizhnik (knizhnik)	Created patch record

Edit