Speed up JSON escape processing with SIMD plus other optimisations

5002

Title

Topic

Performance

Created

2024-05-23 01:24:48

Last modified

2024-08-05 11:37:12 (3 months, 2 weeks ago)

Latest email

2024-08-05 11:26:23 (3 months, 2 weeks ago)

Status

2024-09: Committed

2024-07: Moved to next CF

Target version

Authors

David Rowley (davidrowley)

Reviewers

Become reviewer

Committer

David Rowley (davidrowley)

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/5002
git checkout commitfest/cf/5002

Emails

Speed up JSON escape processing with SIMD plus other optimisations: First at 2024-05-23 01:23:42 by David Rowley <dgrowleyml at gmail.com>
Latest at 2024-08-05 11:26:23 by David Rowley <dgrowleyml at gmail.com>
Latest attachment (intel_i7-1370P.png) at 2024-08-05 11:26:23 from David Rowley <dgrowleyml at gmail.com>
    Attachment (intel_i7-1370P.png) at 2024-08-05 11:26:23 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (json_simd_results.txt) at 2024-08-03 14:11:18 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (setup.sql) at 2024-08-01 04:15:40 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (v5-0001-Optimize-escaping-of-JSON-strings-using-SIMD.patch) at 2024-07-27 12:51:14 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (avoid-possibly-unreachable-palloc.patch.txt) at 2024-07-24 10:55:02 from Heikki Linnakangas <hlinnaka at iki.fi> (Patch: Yes)
    Attachment (v3-0001-Add-len-parameter-to-escape_json.patch) at 2024-07-02 04:49:52 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Add-len-parameter-to-escape_json.patch) at 2024-05-26 23:39:46 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (datum_to_json_internal.patch.txt) at 2024-05-23 02:15:38 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Add-len-parameter-to-escape_json.patch) at 2024-05-23 01:23:42 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)

History

When	Who	What
2024-08-05 11:37:12	David Rowley (davidrowley)	Closed in commitfest 2024-09 with status: Committed
2024-08-05 11:37:12	David Rowley (davidrowley)	Changed committer to davidrowley
2024-08-01 06:25:36	Corey Huinker (coreyh)	Closed in commitfest 2024-07 with status: Moved to next CF
2024-05-23 01:24:57	David Rowley (davidrowley)	Changed authors to David Rowley (davidrowley)
2024-05-23 01:24:48	David Rowley (davidrowley)	Attached mail thread CAApHDvpLXwMZvbCKcdGfU9XQjGCDm7tFpRdTXuB9PVgpNUYfEQ@mail.gmail.com
2024-05-23 01:24:48	David Rowley (davidrowley)	Created patch record