Re: PostGreSQL and zlib - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: PostGreSQL and zlib
Date
Msg-id 873avzmryb.fsf@oxford.xeocode.com
Whole thread Raw
In response to PostGreSQL and zlib  ("Hubert FONGARNAND" <informatique.internet@fiducial.fr>)
Responses Re: PostGreSQL and zlib
List pgsql-hackers
"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


pgsql-hackers by date:

Previous
From: Zdenek Kotala
Date:
Subject: MaxOffsetNumber versus MaxHeapTuplesPerPage
Next
From: Heikki Linnakangas
Date:
Subject: Re: MaxOffsetNumber versus MaxHeapTuplesPerPage