Extract numeric filed in JSONB more effectively

Log in to edit
ID 6644
Title Extract numeric filed in JSONB more effectively
CI (CFBot) Summary
Stats (from CFBot) Patch version: v6, Patch count: 5, First patch: +995−14, All patches: +3155−10
Tags Performance
Created 2026-04-03 07:08:11
Last modified 2026-09-29 06:22:01 (1 month ago)
Latest email 2026-04-27 20:35:57 (6 months ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
Target version
Authors Andy Fan (andyf), Haibo Yan (billyean)
Reviewers Log in to 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-27 20:35:57 by Haibo Yan <tristan.yim at gmail.com>
Latest attachment (v6-0002-jsonb-optimize-array-element-casts-to-scalar-type.patch) at 2026-04-27 20:35:57 from Haibo Yan <tristan.yim at gmail.com>
    Attachment (v6-0002-jsonb-optimize-array-element-casts-to-scalar-type.patch) at 2026-04-27 20:35:57 from Haibo Yan <tristan.yim at gmail.com> (Patch: Yes)
    Attachment (v5-0002-jsonb-optimize-array-element-casts-to-scalar-type.patch) at 2026-04-27 05:01:58 from Haibo Yan <tristan.yim at gmail.com> (Patch: Yes)
    Attachment (v5-0001-jsonb-optimize-object-field-casts-to-scalar-types.patch) at 2026-04-10 21:48:32 from Haibo Yan <tristan.yim at gmail.com> (Patch: Yes)
    Attachment (v4-0001-jsonb-optimize-object-field-casts-to-scalar-types.patch) at 2026-04-08 19:50:50 from Haibo Yan <tristan.yim at gmail.com> (Patch: Yes)
    Attachment (v3-0001-jsonb-optimize-object-field-casts-to-numeric-and-.patch) at 2026-04-07 03:12:04 from Haibo Yan <tristan.yim at gmail.com> (Patch: Yes)
    Attachment (v3-0001-jsonb-optimize-object-field-casts-to-numeric-and-.patch) at 2026-04-06 19:55:29 from Haibo Yan <tristan.yim at gmail.com> (Patch: Yes)
    Attachment (v2-0001-jsonb-optimize-object-field-casts-to-numeric-and-bool.patch) at 2026-04-06 18:35:32 from Haibo Yan <tristan.yim at gmail.com> (Patch: Yes)
    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-09-29 06:22:01 Haibo Yan (billyean) Moved from CF PG20-1 to CF PG20-3
2026-04-07 04:33:03 Haibo Yan (billyean) Changed authors to Andy Fan (andyf), Haibo Yan (billyean)
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
Log in to edit