git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 67427f1) | patch
Optimize escaping of JSON strings
2024年7月27日 11:46:07 +0000 (23:46 +1200)
2024年7月27日 11:46:07 +0000 (23:46 +1200)
commit 17a5871d9d58ea639b6d1ba4f0ce58462d55a33c
Optimize escaping of JSON strings

There were quite a few places where we either had a non-NUL-terminated
string or a text Datum which we needed to call escape_json() on. Many of
these places required that a temporary string was created due to the fact
that escape_json() needs a NUL-terminated cstring. For text types, those
first had to be converted to cstring before calling escape_json() on them.

Here we introduce two new functions to make escaping JSON more optimal:

escape_json_text() can be given a text Datum to append onto the given
buffer. This is more optimal as it foregoes the need to convert the text
Datum into a cstring. A temporary allocation is only required if the text
Datum needs to be detoasted.

escape_json_with_len() can be used when the length of the cstring is
already known or the given string isn't NUL-terminated. Having this
allows various places which were creating a temporary NUL-terminated
string to just call escape_json_with_len() without any temporary memory
allocations.

Discussion: https://postgr.es/m/CAApHDvpLXwMZvbCKcdGfU9XQjGCDm7tFpRdTXuB9PVgpNUYfEQ@mail.gmail.com
Reviewed-by: Melih Mutlu, Heikki Linnakangas
contrib/hstore/hstore_io.c diff | blob | blame | history
src/backend/backup/backup_manifest.c diff | blob | blame | history
src/backend/utils/adt/json.c diff | blob | blame | history
src/backend/utils/adt/jsonb.c diff | blob | blame | history
src/backend/utils/adt/jsonfuncs.c diff | blob | blame | history
src/backend/utils/adt/jsonpath.c diff | blob | blame | history
src/include/utils/json.h diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /