Speed up LockReleaseAll

Edit

ID

Title

Speed up LockReleaseAll

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Topic

Performance

Tags

Created

2021-06-30 06:12:13

Last modified

2021-12-03 07:36:49 (3 years ago)

Latest email

2024-01-09 06:24:19 (1 year ago)

Status

2021-11 (2021-11-01 – 2021-11-30): Returned with feedback

2021-09 (2021-09-01 – 2021-09-30): Moved to different CF

2021-07 (2021-07-01 – 2021-07-31): Moved to different CF

Target version

Authors

David Rowley (davidrowley)

Reviewers

Become reviewer

Committer

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 2024-01-09 06:24:19 by vignesh C <vignesh21 at gmail.com>
Latest attachment (v9-wip-resowner-release-all.patch) at 2023-11-09 16:18:21 from Heikki Linnakangas <hlinnaka at iki.fi>

    Attachment (v9-wip-resowner-release-all.patch) at 2023-11-09 16:18:21 from Heikki Linnakangas <hlinnaka at iki.fi> (Patch: Yes)
    Attachment (v8-0001-wip-resowner-lock-release-all.patch) at 2023-09-18 04:08:55 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v7-0001-wip-resowner-lock-release-all.patch) at 2023-09-11 12:00:10 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    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-12-03 07:36:49	Michael Paquier (michael-kun)	Closed in commitfest 2021-11 with status: Returned with feedback
2021-10-06 16:20:52	Yura Sokolov (funny_falcon)	Posted comment with messageid <163353725266.15437.16597417982943328834.pgcf@coridan.postgresql.org>
2021-10-06 16:20:52	Yura Sokolov (funny_falcon)	New status: Waiting on Author
2021-10-04 16:27:10	Jaime Casanova (jcasanov)	Closed in commitfest 2021-09 with status: Moved to next CF
2021-08-03 02:28:02	Masahiko Sawada (masahikosawada)	Closed in commitfest 2021-07 with status: Moved to next CF
2021-06-30 06:14:08	David Rowley (davidrowley)	Added annotation "New version of patch here" to CAApHDvoKqWRxw5nnUPZ8+mAJKHPOPxYGoY1gQdh0WeS4+biVhg@mail.gmail.com
2021-06-30 06:12:26	David Rowley (davidrowley)	Changed authors to David Rowley (davidrowley)
2021-06-30 06:12:13	David Rowley (davidrowley)	Attached mail thread 0A3221C70F24FB45833433255569204D1FB976EF@G01JPEXMBYT05
2021-06-30 06:12:13	David Rowley (davidrowley)	Created patch record

Edit