Speed up transaction completion faster after many relations are accessed in a transaction

Edit
ID 1993
Title Speed up transaction completion faster after many relations are accessed in a transaction
Topic Performance
Created 2019-02-12 06:03:38
Last modified 2021-06-30 06:14:08 (3 years, 5 months ago)
Latest email 2024-01-09 06:24:19 (10 months, 3 weeks ago)
Status
2020-01: Returned with feedback
2019-11: Moved to next CF
2019-09: Moved to next CF
2019-07: Moved to next CF
2019-03: Moved to next CF
Target version 13
Authors Takayuki Tsunakawa (maumau)
Reviewers Takayuki Tsunakawa (maumau)Become reviewer
Committer David Rowley (davidrowley)
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/1993
git checkout commitfest/cf/1993
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
2021-06-30 06:14:08 David Rowley (davidrowley) Added annotation "New version of patch here" to CAApHDvoKqWRxw5nnUPZ8+mAJKHPOPxYGoY1gQdh0WeS4+biVhg@mail.gmail.com
2020-02-01 11:40:07 Tomas Vondra (fuzzycz) Closed in commitfest 2020-01 with status: Returned with feedback
2019-12-01 02:59:22 Michael Paquier (michael-kun) New status: Waiting on Author
2019-12-01 02:59:18 Michael Paquier (michael-kun) Closed in commitfest 2019-11 with status: Moved to next CF
2019-09-30 18:56:42 Álvaro Herrera (alvherre) Closed in commitfest 2019-09 with status: Moved to next CF
2019-09-27 08:50:07 Peter Eisentraut (petere) Removed petere from reviewers
2019-09-18 14:57:30 Álvaro Herrera (alvherre) New status: Needs review
2019-08-19 20:10:52 Álvaro Herrera (alvherre) Changed targetversion to 13
2019-08-14 07:26:24 David Rowley (davidrowley) Changed authors to Takayuki Tsunakawa (maumau)
2019-08-01 22:13:51 Thomas Munro (macdice) New status: Waiting on Author
2019-08-01 22:13:42 Thomas Munro (macdice) Closed in commitfest 2019-07 with status: Moved to next CF
2019-07-22 06:17:30 Peter Eisentraut (petere) Changed committer to davidrowley
2019-07-22 06:17:20 Peter Eisentraut (petere) Removed petere from committers
2019-04-08 12:10:59 Peter Eisentraut (petere) Closed in commitfest 2019-03 with status: Moved to next CF
2019-04-08 04:06:32 Takayuki Tsunakawa (maumau) Changed authors to David Rowley (davidrowley), Takayuki Tsunakawa (maumau)
2019-04-08 04:06:32 Takayuki Tsunakawa (maumau) Changed reviewers to Peter Eisentraut (petere), Takayuki Tsunakawa (maumau)
2019-04-05 10:57:01 Peter Eisentraut (petere) Added petere as committer
2019-04-05 10:56:58 Peter Eisentraut (petere) New status: Ready for Committer
2019-04-04 04:32:12 Takayuki Tsunakawa (maumau) New status: Needs review
2019-03-25 10:44:48 Peter Eisentraut (petere) New status: Waiting on Author
2019-03-19 07:55:00 Takayuki Tsunakawa (maumau) New status: Needs review
2019-03-18 19:48:19 Peter Eisentraut (petere) New status: Waiting on Author
2019-03-18 19:48:15 Peter Eisentraut (petere) Added petere as reviewer
2019-02-12 06:36:57 Takayuki Tsunakawa (maumau) Attached mail thread 0A3221C70F24FB45833433255569204D1FB976EF@G01JPEXMBYT05
2019-02-12 06:06:15 Takayuki Tsunakawa (maumau) Detached mail thread 9d7c5112-cb99-6a47-d3be-cf1ee6862a1d@lab.ntt.co.jp
2019-02-12 06:05:20 Takayuki Tsunakawa (maumau) Changed targetversion to 12
2019-02-12 06:04:22 Takayuki Tsunakawa (maumau) Changed authors to Takayuki Tsunakawa (maumau)
2019-02-12 06:03:39 Takayuki Tsunakawa (maumau) Attached mail thread 9d7c5112-cb99-6a47-d3be-cf1ee6862a1d@lab.ntt.co.jp
2019-02-12 06:03:38 Takayuki Tsunakawa (maumau) Created patch record
Edit