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, 8 months ago)

Latest email 2020-07-01 09:18:52 (4 years, 4 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