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

2021-06-30 06:14:08 (1 year, 11 months ago)

Latest email

2023-02-10 02:51:07 (3 months, 2 weeks 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 2023-02-10 02:51:07 by David Rowley <dgrowleyml at gmail.com>
Latest attachment (v6-0001-wip-resowner-lock-release-all.patch) at 2023-02-10 02:51:07 from David Rowley <dgrowleyml at gmail.com>

    Attachment (v6-0001-wip-resowner-lock-release-all.patch) at 2023-02-10 02:51:07 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (lockreleaseall_speedup5.patch) at 2023-01-24 03:57:37 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (lockreleaseall_speedup4.patch) at 2022-08-03 03:33:57 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (lockreleaseall_speedup3.patch) at 2022-03-15 02:47:17 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (speedup_releasing_all_locks.patch) at 2022-01-01 01:44:46 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (dense_vs_generic_vs_simple.png) at 2021-07-12 07:23:57 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (v1-0001-Add-a-new-hash-table-type-which-has-stable-pointe.patch) at 2021-06-20 13:56:13 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    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)

Annotations

When	Who	Mail	Annotation
2021-06-30 06:14:08	David Rowley (davidrowley)	From David Rowley <dgrowleyml@gmail.com> at 2021-06-20 13:56:13	New version of patch here

History

When	Who	What
2021-06-30 06:14:08	David Rowley (davidrowley)	Added annotation "New version of patch here" to CAApHDvoKqWRxw5nnUPZ8+mAJKHPOPxYGoY1gQdh0WeS4+biVhg@mail.gmail.com
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