We have submitted TOAST API for PG15.

Below is a performance analysis of JSONB, which uses JSONB TOASTER implemented using TOAST API.

Each jsonb looks like: key1, looong key2[], key3, loong key4[]. Check slide #10 of our talk at pgvision 2021 for description of data and queries used in benchmarks ( Read more... )

Inspired by commit support for partial TOAST decompression"When asked for a slice of a TOAST entry, decompress enough to return the slice instead of decompressing the entire object ( Read more... )