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 (2 weeks, 5 days ago)

Latest email 2024-11-22 18:14:25 (4 weeks, 1 day 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