Implicit prepare of statements: replace literals with parameters and store cached plans

Edit
ID 1150
Title Implicit prepare of statements: replace literals with parameters and store cached plans
Topic Performance
Created 2017-05-25 15:56:03
Last modified 2018-03-06 15:07:57 (6 years, 9 months ago)
Latest email 2020-07-01 09:18:52 (4 years, 5 months ago)
Status
2018-03: Returned with feedback
2018-01: Moved to next CF
2017-11: Moved to next CF
2017-09: Moved to next CF
Target version
Authors Konstantin Knizhnik (knizhnik)
Reviewers Become reviewer
Committer
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/1150
git checkout commitfest/cf/1150
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
2018-08-01 00:19:27 Takayuki Tsunakawa (maumau) Removed maumau from reviewers
2018-03-06 15:07:57 David Steele (dsteele) Closed in commitfest 2018-03 with status: Returned with feedback
2018-02-07 15:42:29 David Steele (dsteele) Closed in commitfest 2018-01 with status: Moved to next CF
2018-01-06 22:50:58 Stephen Frost (sfrost) New status: Needs review
2017-11-30 01:58:57 Michael Paquier (michael-kun) New status: Waiting on Author
2017-11-30 01:58:51 Michael Paquier (michael-kun) Closed in commitfest 2017-11 with status: Moved to next CF
2017-10-26 04:37:28 Takayuki Tsunakawa (maumau) Added maumau as reviewer
2017-10-01 22:41:26 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2017-09 with status: Moved to next CF
2017-05-25 15:56:36 Konstantin Knizhnik (knizhnik) Changed authors to Konstantin Knizhnik (knizhnik)
2017-05-25 15:56:03 Konstantin Knizhnik (knizhnik) Attached mail thread 8e76d8fc-8b8c-14bd-d4d1-e9cf193a74f5@postgrespro.ru
2017-05-25 15:56:03 Konstantin Knizhnik (knizhnik) Created patch record
Edit