Speed up releasing of locks

Edit
Title Speed up releasing of locks
Topic Performance
Created 2022-01-01 01:46:59
Last modified 2022-04-07 04:06:40 (2 months, 2 weeks ago)
Latest email 2022-04-07 04:05:19 (2 months, 2 weeks ago)
Status
2022-07: Needs review
2022-03: Moved to next CF
2022-01: Moved to next CF
Target version
Authors Andres Freund (andresfreund), 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 2022-04-07 04:05:19 by David Rowley <dgrowleyml at gmail.com>
Latest attachment (lockreleaseall_speedup3.patch) at 2022-03-15 02:47:17 from David Rowley <dgrowleyml at gmail.com>
    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
2022-04-07 04:06:40 David Rowley (davidrowley) Closed in commitfest 2022-03 with status: Moved to next CF
2022-02-02 16:33:52 Julien Rouhaud (rjuju) Closed in commitfest 2022-01 with status: Moved to next CF
2022-01-01 01:47:19 David Rowley (davidrowley) Changed authors to Andres Freund (andresfreund), David Rowley (davidrowley)
2022-01-01 01:47:00 David Rowley (davidrowley) Attached mail thread 0A3221C70F24FB45833433255569204D1FB976EF@G01JPEXMBYT05
2022-01-01 01:46:59 David Rowley (davidrowley) Created patch record
Edit