Suppose, most time is spent for decompressing huge value, not for actual search inside jsonb. If so, we need to implement some search method which decompress some chunks of jsonb.
On artificial example: %SAMP IMAGE FUNCTION CALLERS 92.9 postgres pglz_decompress toast_decompress_datum -- Teodor Sigaev E-mail: teodor@xxxxxxxxx WWW: http://www.sigaev.ru/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general