On Wed, Mar 6, 2024 at 9:22 PM jian he <jian.universal...@gmail.com> wrote: > > Another case, I did test yet: more keys in a single json, but the > value is small.
Another case attached. see the attached SQL file's comments.
a single simple jsonb, with 33 keys, each key's value with fixed length: 256.
total table size: SELECT pg_size_pretty(pg_table_size('json33keys')); --5369 MB
number of rows: 600001.
using the previously mentioned method: pg_log_backend_memory_contexts.
all these tests under:
-Dcassert=true \
-Db_coverage=true \
-Dbuildtype=debug \
I hope someone will tell me if the test method is correct or not.
jsonb_33keys.sql
Description: application/sql
