"Hubert FONGARNAND" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend