Speed up transaction completion faster after many relations are accessed in a transaction

Edit

Title

Topic

Performance

Created

2019-02-12 06:03:38

Last modified

2020-02-01 11:40:07 (5 months ago)

Latest email

2020-02-01 11:41:09 (5 months ago)

Status

2020-01: Returned with feedback

2019-11: Moved to next CF

2019-09: Moved to next CF

2019-07: Moved to next CF

2019-03: Moved to next CF

Target version

Authors

Takayuki Tsunakawa (maumau)

Reviewers

Takayuki Tsunakawa (maumau)Become reviewer

Committer

David Rowley (davidrowley)

Links

Emails

Speed up transaction completion faster after many relations are accessed in a transaction: First at 2019-02-12 06:33:00 by "Tsunakawa, Takayuki" <tsunakawa.takay at jp.fujitsu.com>
Latest at 2020-02-01 11:41:09 by Tomas Vondra <tomas.vondra at 2ndquadrant.com>
Latest attachment (faster-locallock-scan_v3.patch) at 2019-09-26 07:11:53 from "Tsunakawa, Takayuki" <tsunakawa.takay at jp.fujitsu.com>
    Attachment (faster-locallock-scan_v3.patch) at 2019-09-26 07:11:53 from "Tsunakawa, Takayuki" <tsunakawa.takay at jp.fujitsu.com> (Patch: Yes)
    Attachment (shrink_bloated_locallocktable_v8.patch) at 2019-07-24 07:14:35 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (shrink_bloated_locallocktable_v8_demo.patch) at 2019-07-24 04:16:47 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (hash_reset_logic.ods) at 2019-07-24 03:05:37 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: No)
    Attachment (shrink_bloated_locallocktable_v7.patch) at 2019-07-23 06:11:51 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (shrink_bloated_locallocktable_v6.patch) at 2019-07-21 09:37:28 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (shrink_bloated_locallocktable_v5.patch) at 2019-06-26 23:00:56 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (shrink_bloated_locallocktable_v4.patch) at 2019-06-15 03:28:05 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (shrink_bloated_locallocktable_v3.patch) at 2019-04-07 16:48:11 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (shrink_bloated_locallocktable_v2.patch) at 2019-04-07 15:40:52 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (shrink_bloated_locallocktable.patch) at 2019-04-07 13:55:31 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-reorder-LOCALLOCK-structure-members-to-compact-the-s.patch) at 2019-03-19 09:21:42 from "Tsunakawa, Takayuki" <tsunakawa.takay at jp.fujitsu.com> (Patch: Yes)
    Attachment (0001-reorder-LOCALLOCK-structure-members-to-compact-the-s.patch) at 2019-03-19 07:53:27 from "Tsunakawa, Takayuki" <tsunakawa.takay at jp.fujitsu.com> (Patch: Yes)
    Attachment (faster-locallock-scan_v2.patch) at 2019-02-20 06:20:37 from "Tsunakawa, Takayuki" <tsunakawa.takay at jp.fujitsu.com> (Patch: Yes)
    Attachment (faster-locallock-scan.patch) at 2019-02-12 06:33:00 from "Tsunakawa, Takayuki" <tsunakawa.takay at jp.fujitsu.com> (Patch: Yes)

History

When	Who	What
2020-02-01 11:40:07	Tomas Vondra (fuzzycz)	Closed in commitfest 2020-01 with status: Returned with feedback
2019-12-01 02:59:22	Michael Paquier (michael-kun)	New status: Waiting on Author
2019-12-01 02:59:18	Michael Paquier (michael-kun)	Closed in commitfest 2019-11 with status: Moved to next CF
2019-09-30 18:56:42	Álvaro Herrera (alvherre)	Closed in commitfest 2019-09 with status: Moved to next CF
2019-09-27 08:50:07	Peter Eisentraut (petere)	Removed petere from reviewers
2019-09-18 14:57:30	Álvaro Herrera (alvherre)	New status: Needs review
2019-08-19 20:10:52	Álvaro Herrera (alvherre)	Changed targetversion to 13
2019-08-14 07:26:24	David Rowley (davidrowley)	Changed authors to Takayuki Tsunakawa (maumau)
2019-08-01 22:13:51	Thomas Munro (macdice)	New status: Waiting on Author
2019-08-01 22:13:42	Thomas Munro (macdice)	Closed in commitfest 2019-07 with status: Moved to next CF
2019-07-22 06:17:30	Peter Eisentraut (petere)	Changed committer to davidrowley
2019-07-22 06:17:20	Peter Eisentraut (petere)	Removed petere from committers
2019-04-08 12:10:59	Peter Eisentraut (petere)	Closed in commitfest 2019-03 with status: Moved to next CF
2019-04-08 04:06:32	Takayuki Tsunakawa (maumau)	Changed authors to David Rowley (davidrowley), Takayuki Tsunakawa (maumau)
2019-04-08 04:06:32	Takayuki Tsunakawa (maumau)	Changed reviewers to Peter Eisentraut (petere), Takayuki Tsunakawa (maumau)
2019-04-05 10:57:01	Peter Eisentraut (petere)	Added petere as committer
2019-04-05 10:56:58	Peter Eisentraut (petere)	New status: Ready for Committer
2019-04-04 04:32:12	Takayuki Tsunakawa (maumau)	New status: Needs review
2019-03-25 10:44:48	Peter Eisentraut (petere)	New status: Waiting on Author
2019-03-19 07:55:00	Takayuki Tsunakawa (maumau)	New status: Needs review
2019-03-18 19:48:19	Peter Eisentraut (petere)	New status: Waiting on Author
2019-03-18 19:48:15	Peter Eisentraut (petere)	Added petere as reviewer
2019-02-12 06:36:57	Takayuki Tsunakawa (maumau)	Attached mail thread 0A3221C70F24FB45833433255569204D1FB976EF@G01JPEXMBYT05
2019-02-12 06:06:15	Takayuki Tsunakawa (maumau)	Detached mail thread 9d7c5112-cb99-6a47-d3be-cf1ee6862a1d@lab.ntt.co.jp
2019-02-12 06:05:20	Takayuki Tsunakawa (maumau)	Changed targetversion to 12
2019-02-12 06:04:22	Takayuki Tsunakawa (maumau)	Changed authors to Takayuki Tsunakawa (maumau)
2019-02-12 06:03:39	Takayuki Tsunakawa (maumau)	Attached mail thread 9d7c5112-cb99-6a47-d3be-cf1ee6862a1d@lab.ntt.co.jp
2019-02-12 06:03:38	Takayuki Tsunakawa (maumau)	Created patch record

Edit