Speed up releasing of locks

Edit

ID 3501

Title Speed up releasing of locks

Topic Performance

Created 2022-01-01 01:46:59

Last modified 2024-05-08 01:23:25 (6 months, 1 week ago)

Latest email 2024-01-09 06:24:19 (10 months, 1 week ago)

Status

2024-07: Withdrawn

2024-03: Moved to next CF

2024-01: Moved to next CF

2023-11: Moved to next CF

2023-09: Moved to next CF

2023-07: Moved to next CF

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 Heikki Linnakangas (heikki)Become reviewer

Committer

Links CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/3501
git checkout commitfest/cf/3501

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
2024-05-08 01:23:25	David Rowley (davidrowley)	Closed in commitfest 2024-07 with status: Withdrawn
2024-04-08 08:00:54	Andrey Borodin (x4m)	Closed in commitfest 2024-03 with status: Moved to next CF
2024-02-01 18:40:59	vigneshwaran C (vignesh.postgres)	Closed in commitfest 2024-01 with status: Moved to next CF
2024-01-27 03:03:59	vigneshwaran C (vignesh.postgres)	New status: Waiting on Author
2023-12-04 09:44:37	John Naylor (john.naylor)	Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-02 11:04:32	Peter Eisentraut (petere)	Closed in commitfest 2023-09 with status: Moved to next CF
2023-09-26 08:55:33	Peter Eisentraut (petere)	New status: Needs review
2023-09-15 10:38:18	Heikki Linnakangas (heikki)	New status: Waiting on Author
2023-09-13 23:40:11	David Rowley (davidrowley)	New status: Needs review
2023-08-01 18:16:15	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2023-07 with status: Moved to next CF
2023-07-05 09:53:04	Heikki Linnakangas (heikki)	New status: Waiting on Author
2023-07-05 09:53:01	Heikki Linnakangas (heikki)	Added heikki as reviewer
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