Re: [HACKERS] PostGreSQL and zlib

2007-10-25 Thread Martijn van Oosterhout
On Thu, Oct 25, 2007 at 01:49:57PM +0200, Hubert FONGARNAND wrote: > Another question : does this TOAST code works for all type of data, like > TEXT (in our case) Yes. Have a nice day, -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > From each according to his abilit

Re: [HACKERS] PostGreSQL and zlib

2007-10-25 Thread Hubert FONGARNAND
The problem is that for TOAST columns : "The compression technique used is a fairly simple and very fast member of the LZ family of compression techniques. See src/backend/utils/adt/pg_lzcompress.c for the details." With such function you could choose you compression algorithm and compression level

Re: [HACKERS] PostGreSQL and zlib

2007-10-25 Thread Gregory Stark
"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

[HACKERS] PostGreSQL and zlib

2007-10-25 Thread Hubert FONGARNAND
Hi everybody, I'm looking for using zlib function directly in the database : Example : a function "zipit" that would take a bytea as argument and returns a compressed bytea and an "unzipit" that would take a compressed bytea as argument and returns a uncompressed bytea I'm sure it's very easy to