Speed up releasing of locks

Edit

Title

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