Extract numeric field in JSONB more effectively

Edit
ID 4476
Title Extract numeric field in JSONB more effectively
Topic Performance
Created 2023-08-03 00:36:21
Last modified 2024-12-01 19:10:43 (1 week, 3 days ago)
Latest email 2024-11-22 18:14:25 (2 weeks, 5 days ago)
Status
2025-01: Needs review
2024-11: Moved to next CF
2024-09: Moved to next CF
2024-07: Moved to next CF
2024-03: Moved to next CF
2024-01: Moved to next CF
2023-11: Moved to next CF
2023-09: Moved to next CF
Target version
Authors Andy Fan (andyf)
Reviewers Chapman Flack (chap)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/4476
git checkout commitfest/cf/4476
Emails
Extract numeric filed in JSONB more effectively
First at 2023-08-01 04:38:57 by Andy Fan <zhihui.fan1213 at gmail.com>
Latest at 2024-11-22 18:14:25 by Dmitry Dolgov <9erthalion6 at gmail.com>
Latest attachment (jsonb_numeric_support.patch.txt) at 2024-09-11 21:00:41 from David Rowley <dgrowleyml at gmail.com>
    Attachment (jsonb_numeric_support.patch.txt) at 2024-09-11 21:00:41 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Improve-the-performance-of-Jsonb-numeric-bool-ex.patch) at 2024-04-17 05:13:34 from Andy Fan <zhihuifan1213 at 163.com> (Patch: Yes)
    Attachment (v17-0001-Improve-the-performance-of-Jsonb-numeric-bool-ex.patch) at 2024-04-01 01:42:12 from Andy Fan <zhihuifan1213 at 163.com> (Patch: Yes)
    Attachment (v16-0001-Improve-the-performance-of-Jsonb-numeric-bool-ex.patch) at 2024-02-09 09:05:21 from Andy Fan <zhihuifan1213 at 163.com> (Patch: Yes)
    Attachment (v16-0001-Improve-the-performance-of-Jsonb-extraction.patch) at 2024-01-08 00:00:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Improve-the-performance-of-Jsonb-extraction.patch) at 2023-11-06 03:26:28 from zhihuifan1213 at 163.com (Patch: Yes)
    Attachment (v14-0002-try-to-apply-jsonb-extraction-optimization-to-_t.patch) at 2023-09-15 01:53:20 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v13-0001-optimize-casting-jsonb-to-a-given-type.patch) at 2023-09-04 14:35:16 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v12-0001-optimize-casting-jsonb-to-a-given-type.patch) at 2023-09-01 03:09:22 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v11-0001-optimize-casting-jsonb-to-a-given-type.patch) at 2023-08-31 09:10:39 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v10-0003-relabel-the-arg-and-resultvalue-with-INTERNALOID.patch) at 2023-08-22 03:14:48 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v10-0001-optimize-casting-jsonb-to-a-given-type.patch) at 2023-08-21 01:31:56 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (0001-convert-anyelement-to-internal.patch) at 2023-08-18 07:41:13 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (test.sql) at 2023-08-17 09:07:31 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: No)
    Attachment (v8-0001-optimize-casting-jsonb-to-a-given-type.patch) at 2023-08-16 06:27:57 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v8-0001-optimize-casting-jsonb-to-a-given-type.patch.bak) at 2023-08-16 06:12:16 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v7-0001-optimize-casting-jsonb-to-a-given-type.patch) at 2023-08-15 03:24:35 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v6-0001-optimize-casting-jsonb-to-a-given-type.patch) at 2023-08-14 15:42:12 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v5-0001-optimize-casting-jsonb-to-a-given-type.patch) at 2023-08-10 08:03:15 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Optimize-extracting-a-given-data-type-from-jsonb.patch) at 2023-08-07 07:32:25 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Optimize-extracting-a-given-data-type-from-jsonb.patch) at 2023-08-07 03:04:05 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Add-jsonb-operator-to-return-a-numeric-directly.patch) at 2023-08-03 00:50:47 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Add-jsonb-operator-to-return-a-numeric-directly.patch) at 2023-08-01 04:38:57 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
History
When Who What
2024-12-01 19:10:43 Dmitry Dolgov (erthalion) Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-07 07:19:10 Michael Paquier (michael-kun) Closed in commitfest 2024-09 with status: Moved to next CF
2024-10-07 07:19:06 Michael Paquier (michael-kun) New status: Needs review
2024-09-12 01:08:37 David Rowley (davidrowley) New status: Waiting on Author
2024-08-01 01:57:36 Corey Huinker (coreyh) Closed in commitfest 2024-07 with status: Moved to next CF
2024-04-09 06:23:36 Andrey Borodin (x4m) Closed in commitfest 2024-03 with status: Moved to next CF
2024-04-09 06:23:32 Andrey Borodin (x4m) Changed targetversion to None
2024-02-01 17:46:12 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Moved to next CF
2023-12-04 09:48:10 John Naylor (john.naylor) Closed in commitfest 2023-11 with status: Moved to next CF
2023-11-02 14:19:24 John Naylor (john.naylor) New status: Needs review
2023-11-01 02:17:24 Chapman Flack (chap) Posted comment with messageid <169880504467.94392.3769687331705514588.pgcf@coridan.postgresql.org>
2023-10-05 06:53:31 Andy Fan (andyf) New status: Ready for Committer
2023-10-02 11:09:21 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Moved to next CF
2023-08-20 14:56:04 Chapman Flack (chap) Changed name to Extract numeric field in JSONB more effectively
2023-08-08 20:18:26 Chapman Flack (chap) Added chap as reviewer
2023-08-03 00:36:40 Andy Fan (andyf) Changed authors to Andy Fan (andyf)
2023-08-03 00:36:40 Andy Fan (andyf) Changed targetversion to 17
2023-08-03 00:36:21 Andy Fan (andyf) Attached mail thread CAKU4AWoqAVya6PBhn+BCbFaBMt3z-2=i5fKO3bW=6HPhbid2Dw@mail.gmail.com
2023-08-03 00:36:21 Andy Fan (andyf) Created patch record
Edit