Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...

From: JanWieck(at)t-online(dot)de (Jan Wieck)
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Jan Wieck <JanWieck(at)Yahoo(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL HACKERS <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...
Date: 2000-07-07 19:47:10
Message-ID: 200007071947.VAA26359@hot.jw.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-sql

eisentrp(at)csis(dot)gvsu(dot)edu wrote:
> Maybe you just want to use zlib. Let other guys hammer out the details.
>

We cannot assume that zlib is available everywhere. Thus it
must be determined during configure and where it isn't, TOAST
can only move off values to make tuples fit into blocks.
Since decompression of already in memory items is alot faster
than doing an index scan on the TOAST table, I expect this to
make installations without zlib damned slow.

And how should binary distributions like RPM's handle it? I
assume that this problem is already on it's way because of
the integration of zlib into pg_dump. The only way I see is
having different RPM's for each possible combination of
available helper libs. Or is there another way to work
around?

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2000-07-07 19:55:43 Re: A Referntial integrity
Previous Message Peter Eisentraut 2000-07-07 19:27:11 Re: proposed improvements to PostgreSQL license

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Nfor 2000-07-07 21:19:52 psql mode for emacs
Previous Message Darren King 2000-07-07 19:42:30 RE: Lessons learned on how to build 7.0.2 on AIX 4.x

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-07-07 21:56:12 Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...
Previous Message Antoine Reid 2000-07-07 19:32:23 Re: confused by select.