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

Edit

1150

Title

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Topic

Performance

Tags

Created

2017-05-25 15:56:03

Last modified

2018-03-06 15:07:57 (7 years ago)

Latest email

2020-07-01 09:18:52 (4 years ago)

Status

2018-03 (2018-03-01 - 2018-03-31): Returned with feedback

2018-01 (2018-01-01 - 2018-01-31): Moved to different CF

2017-11 (2017-11-01 - 2017-11-30): Moved to different CF

2017-09 (2017-09-01 - 2017-09-30): Moved to different CF

Target version

Authors

Konstantin Knizhnik (knizhnik)

Reviewers

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
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