Extract numeric field in JSONB more effectively

Edit

4476

Title

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Topic

Performance

Tags

Created

2023-08-03 00:36:21

Last modified

2024-12-01 19:10:43 (6 months ago)

Latest email

2024-11-22 18:14:25 (7 months ago)

Status

2025-01 (2025-01-01 - 2025-01-31): Needs review

2024-11 (2024-11-01 - 2024-11-30): Moved to different CF

2024-09 (2024-09-01 - 2024-09-30): Moved to different CF

2024-07 (2024-07-01 - 2024-07-31): Moved to different CF

2024-03 (2024-03-01 - 2024-04-08): Moved to different CF

2024-01 (2024-01-01 - 2024-01-31): Moved to different CF

2023-11 (2023-11-01 - 2023-12-04): Moved to different CF

2023-09 (2023-09-01 - 2023-09-30): Moved to different CF

Target version

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-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