Speed up releasing of locks

Edit
Title Speed up releasing of locks
Topic Performance
Created 2022-01-01 01:46:59
Last modified 2022-10-12 07:03:26 (1 month, 3 weeks ago)
Latest email 2022-11-15 21:03:50 (3 weeks, 1 day ago)
Status
2022-11: Needs review
2022-09: Moved to next CF
2022-07: Moved to next CF
2022-03: Moved to next CF
2022-01: Moved to next CF
Target version
Authors Andres Freund (andresfreund), David Rowley (davidrowley)
Reviewers Ankit Kumar Pandey (ankitkpandey)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-11-15 21:03:50 by David Rowley <dgrowleyml at gmail.com>
Latest attachment (lockreleaseall_speedup4.patch) at 2022-08-03 03:33:57 from David Rowley <dgrowleyml at gmail.com>
    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
2022-11-03 15:42:10 Ankit Kumar Pandey (ankitkpandey) Added ankitkpandey as reviewer
2022-11-03 15:42:05 Ankit Kumar Pandey (ankitkpandey) Posted comment with messageid <166749012522.1122.11683450499316408651.pgcf@coridan.postgresql.org>
2022-10-12 07:03:26 Michael Paquier (michael-kun) Closed in commitfest 2022-09 with status: Moved to next CF
2022-08-03 03:34:39 David Rowley (davidrowley) Closed in commitfest 2022-07 with status: Moved to next CF
2022-08-03 03:34:17 David Rowley (davidrowley) New status: Needs review
2022-08-02 19:04:03 Jacob Champion (jchampion) Closed in commitfest 2022-07 with status: Returned with feedback
2022-07-22 20:53:17 Jacob Champion (jchampion) New status: Waiting on Author
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