On Thu, 2023-04-27 at 11:44 +0200, Dominique Devienne wrote: > as someone who must store ZLIB (from ZIP files) > and sometimes LZ4 compressed `bytea` values, I often find it's a shame that I > have > to decompress them, send them over the wire uncompressed, to have the > PostgreSQL > backend recompress them when TOAST'ed. That's a waste of CPU and IO > bandwidth...
That's not what you were looking for, but why not store the compressed data in the database (after SET STORAGE EXTERNAL on the column) and uncompress them after you have received them on the client side? Yours, Laurenz Albe
