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

Jan Wieck <janwieck@t-online.de>

From: JanWieck@t-online.de (Jan Wieck)
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Jan Wieck <JanWieck@Yahoo.com>, Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL HACKERS <pgsql-hackers@postgresql.org>
Date: 2000-07-07T19:47:10Z
Lists: pgsql-hackers
eisentrp@csis.gvsu.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@Yahoo.com #