nbtree performance improvements through specialization on key shape

Edit
Title nbtree performance improvements through specialization on key shape
Topic Performance
Created 2022-06-05 19:03:37
Last modified 2023-04-09 03:21:29 (1 month, 2 weeks ago)
Latest email 2023-04-04 15:42:54 (1 month, 3 weeks ago)
Status
2023-07: Waiting on Author
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
Target version
Authors Matthias van de Meent (mmeent)
Reviewers David Christensen (davidchristensen)Become reviewer
Committer
Links
Emails
Improving btree performance through specializing by key shape, take 2
First at 2022-04-08 16:54:55 by Matthias van de Meent <boekewurm+postgres at gmail.com>
Latest at 2023-04-04 15:42:54 by "Gregory Stark (as CFM)" <stark.cfm at gmail.com>
Latest attachment (v10-0004-Optimize-nbts_attiter-for-nkeyatts-1-btrees.patch) at 2023-02-08 18:46:12 from Matthias van de Meent <boekewurm+postgres at gmail.com>
    Attachment (v10-0004-Optimize-nbts_attiter-for-nkeyatts-1-btrees.patch) at 2023-02-08 18:46:12 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (v9-0005-Add-an-attcacheoff-populating-function.patch) at 2023-01-23 13:54:01 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (Perf_results.xlsx) at 2023-01-20 19:37:58 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: No)
    Attachment (v7-0001-Implement-dynamic-prefix-compression-in-nbtree.patch) at 2022-10-31 18:14:08 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (v6-0005-Add-a-function-whose-task-it-is-to-populate-all-a.patch) at 2022-07-27 11:34:52 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (v5-0002-Use-specialized-attribute-iterators-in-backend-nb.patch) at 2022-07-27 07:35:24 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (pgbench_log.patched_v4.txt) at 2022-07-04 14:18:35 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: No)
    Attachment (performance_comparison.txt) at 2022-06-05 19:12:36 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: No)
    Attachment (v2-0002-Use-specialized-attribute-iterators-in-backend-nb.patch) at 2022-04-15 23:05:27 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (v1-0007-Add_missed_declarations_for__bt_keep_natts.patch) at 2022-04-10 23:07:46 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (v1-0004-Implement-specialized-uncacheable-attribute-itera.patch) at 2022-04-08 16:54:55 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
History
When Who What
2023-04-09 03:21:29 Greg Stark (stark) Changed targetversion to None
2023-04-09 02:13:11 Greg Stark (stark) Closed in commitfest 2023-03 with status: Moved to next CF
2023-04-09 02:12:47 Greg Stark (stark) New status: Waiting on Author
2023-03-06 15:37:26 Stephen Frost (sfrost) Changed reviewers to David Christensen (davidchristensen)
2023-01-31 16:16:18 vigneshwaran C (vignesh.postgres) Closed in commitfest 2023-01 with status: Moved to next CF
2023-01-20 21:34:36 Matthias van de Meent (mmeent) New status: Needs review
2023-01-20 16:47:00 David Christensen (dwc-pgguru) New status: Waiting on Author
2023-01-12 15:10:42 David Christensen (dwc-pgguru) Posted comment with messageid <167353624210.1137.16548898709474282094.pgcf@coridan.postgresql.org>
2023-01-06 20:02:20 David Christensen (dwc-pgguru) Added dwc-pgguru as reviewer
2022-12-12 13:28:39 Ian Barwick (barwick) Closed in commitfest 2022-11 with status: Moved to next CF
2022-10-31 18:19:47 Matthias van de Meent (mmeent) New status: Needs review
2022-10-12 07:47:46 Michael Paquier (michael-kun) Closed in commitfest 2022-09 with status: Moved to next CF
2022-10-12 07:47:43 Michael Paquier (michael-kun) New status: Waiting on Author
2022-08-01 21:15:55 Jacob Champion (jchampion) Closed in commitfest 2022-07 with status: Moved to next CF
2022-07-04 14:19:28 Matthias van de Meent (mmeent) New status: Needs review
2022-06-20 19:18:19 Matthias van de Meent (mmeent) New status: Waiting on Author
2022-06-05 19:04:03 Matthias van de Meent (mmeent) Changed authors to Matthias van de Meent (mmeent)
2022-06-05 19:04:03 Matthias van de Meent (mmeent) Changed targetversion to 16
2022-06-05 19:03:37 Matthias van de Meent (mmeent) Attached mail thread CAEze2Wg52tsSWA9Fy7OCXx-K7pPLMNxA_fmQ6-+_pzR-AoODDA@mail.gmail.com
2022-06-05 19:03:37 Matthias van de Meent (mmeent) Created patch record
Edit