Re: PostGreSQL and zlib

"Hubert FONGARNAND" <informatique.internet@fiducial.fr> writes:

> I'm sure it's very easy to implement as a C function that would call zlib
>
> Is there already an implementation of such things?

Not that I'm aware though you might look at pgcrypto. Good crypto has to
compress first so there may be a possibility of just doing the compression.

Postgres also will automatically try to compress data like byteas if the
record is larger than 2kB (1/4 of the block size if you've changed the block
size). So you may not have to do anything if you're just looking to save space
on disk.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com