Extract numeric filed in JSONB more effectively

Edit
ID 6644
Title Extract numeric filed in JSONB more effectively
CI (CFBot) Summary
Stats (from CFBot) Patch count: 1, First patch: +452−5, All patches: +452−5
Tags Performance
Created 2026-04-03 07:08:11
Last modified 2026-04-03 15:45:58 (2 days ago)
Latest email 2026-04-03 16:42:20 (2 days ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Needs review
Target version
Authors Haibo Yan (billyean)
Reviewers Become reviewer
Committer
Links
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 2026-04-03 16:42:20 by Haibo Yan <tristan.yim at gmail.com>
Latest attachment (0001-jsonb-optimize-object-field-casts-to-numeric-and-boo.patch) at 2026-04-03 04:46:22 from Haibo Yan <tristan.yim at gmail.com>
    Attachment (0001-jsonb-optimize-object-field-casts-to-numeric-and-boo.patch) at 2026-04-03 04:46:22 from Haibo Yan <tristan.yim at gmail.com> (Patch: Yes)
    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
2026-04-03 15:45:58 Haibo Yan (billyean) Attached mail thread CAKU4AWoqAVya6PBhn+BCbFaBMt3z-2=i5fKO3bW=6HPhbid2Dw@mail.gmail.com
2026-04-03 15:44:42 Haibo Yan (billyean) Detached mail thread CAKU4AWoqAVya6PBhn+BCbFaBMt3z-2=i5fKO3bW=6HPhbid2Dw@mail.gmail.com
2026-04-03 07:08:11 Haibo Yan (billyean) Attached mail thread CAKU4AWoqAVya6PBhn+BCbFaBMt3z-2=i5fKO3bW=6HPhbid2Dw@mail.gmail.com
2026-04-03 07:08:11 Haibo Yan (billyean) Created patch record
Edit