Extract numeric field in JSONB more effectively

Edit
Title Extract numeric field in JSONB more effectively
Topic Performance
Created 2023-08-03 00:36:21
Last modified 2024-02-01 17:46:12 (4 weeks ago)
Latest email 2024-02-09 09:05:21 (2 weeks, 6 days ago)
Status
2024-03: Needs review
2024-01: Moved to next CF
2023-11: Moved to next CF
2023-09: Moved to next CF
Target version 17
Authors Andy Fan (andyf)
Reviewers Chapman Flack (chap)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 2024-02-09 09:05:21 by Andy Fan <zhihuifan1213 at 163.com>
Latest 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>
    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-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