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, 4 months ago)

Latest email 2024-01-09 06:24:19 (10 months, 1 week 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