Read one field, not the complete document¶
0.1.0 ยท research definition
jsonb_slice is a PostgreSQL extension experiment. It studies partial reads
of large jsonb values. The test case is simple: a query needs one small
field, but the stored document is large.
Version 0.1.0 describes the experiment and installs the extension shell. It does not provide a JSONB accessor.
Question¶
Can an extension find one field in an uncompressed, out-of-line jsonb value
and fetch only the TOAST chunks that hold the answer?
Required result¶
For each supported input, the result must equal the result from PostgreSQL. For each unsupported input, PostgreSQL must do the work.
What 0.1.0 contains¶
- a PGXS package that installs
jsonb_slice; - a regression test for create, version, empty membership, and drop behavior;
- a PostgreSQL-style C format configuration and CI check;
- an explanation of the research question;
- an explicit statement of the current limits;
- a versioned documentation and Pages build;
- a tagged source archive with a SHA-256 checksum.
What 0.1.0 does not contain¶
- C source;
- SQL functions or operators;
- benchmark results;
- a production support promise.
These omissions define the current release. They are not hidden features.
Experimental work
Install this version only in a test database. It creates the extension identity but does not change JSONB query behavior.