Speed up releasing of locks

Edit
Title Speed up releasing of locks
Topic Performance
Created 2022-01-01 01:46:59
Last modified 2023-04-09 02:32:07 (1 month, 4 weeks ago)
Latest email 2023-02-10 02:51:07 (3 months, 3 weeks ago)
Status
2023-07: Needs review
2023-03: Moved to next CF
2023-01: Moved to next CF
2022-11: Moved to next CF
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 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 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
2023-04-09 02:32:07 Greg Stark (stark) Closed in commitfest 2023-03 with status: Moved to next CF
2023-03-15 14:15:27 Ankit Kumar Pandey (ankitkpandey) Removed ankitkpandey from reviewers
2023-01-31 16:16:14 vigneshwaran C (vignesh.postgres) Closed in commitfest 2023-01 with status: Moved to next CF
2022-12-12 23:19:20 Ian Barwick (barwick) Closed in commitfest 2022-11 with status: Moved to next CF
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