]> granicus.if.org Git - postgresql/commit
Optimize partial TOAST decompression
authorTomas Vondra <tomas.vondra@postgresql.org>
Tue, 1 Oct 2019 12:13:44 +0000 (14:13 +0200)
committerTomas Vondra <tomas.vondra@postgresql.org>
Tue, 1 Oct 2019 12:28:28 +0000 (14:28 +0200)
commit11a078cf87ffb611d19c7dec6df68b41084ad9c9
treecdb79b0578ea99a1c090d2704d4d5f0aa9266dc9
parent002962dc7293043126561b0d0df79d6c76251804
Optimize partial TOAST decompression

Commit 4d0e994eed added support for partial TOAST decompression, so the
decompression is interrupted after producing the requested prefix. For
prefix and slices near the beginning of the entry, this may saves a lot
of decompression work.

That however only deals with decompression - the whole compressed entry
was still fetched and re-assembled, even though the compression used
only a small fraction of it. This commit improves that by computing how
much compressed data may be needed to decompress the requested prefix,
and then fetches only the necessary part.

We always need to fetch a bit more compressed data than the requested
(uncompressed) prefix, because the prefix may not be compressible at all
and pglz itself adds a bit of overhead. That means this optimization is
most effective when the requested prefix is much smaller than the whole
compressed entry.

Author: Binguo Bao
Reviewed-by: Andrey Borodin, Tomas Vondra, Paul Ramsey
Discussion: https://www.postgresql.org/message-id/flat/CAL-OGkthU9Gs7TZchf5OWaL-Gsi=hXqufTxKv9qpNG73d5na_g@mail.gmail.com
src/backend/access/common/detoast.c
src/common/pg_lzcompress.c
src/include/access/toast_internals.h
src/include/common/pg_lzcompress.h