Received: from mailout00.sul.t-online.com (mailout00.sul.t-online.com [194.25.134.16]) by hub.org (8.10.1/8.10.1) with ESMTP id e67KjfW14828 for ; Fri, 7 Jul 2000 16:45:41 -0400 (EDT) Received: from fwd04.sul.t-online.com by mailout00.sul.t-online.com with smtp id 13Af0G-0005Uf-03; Fri, 7 Jul 2000 22:45:40 +0200 Received: from hot.jw.home (340000654369-0001@[62.156.33.73]) by fwd04.sul.t-online.com with esmtp id 13Af09-1TtMJMC; Fri, 7 Jul 2000 22:45:33 +0200 Received: (from wieck@localhost) by hot.jw.home (8.8.5/8.8.5) id VAA26359; Fri, 7 Jul 2000 21:47:10 +0200 From: JanWieck@t-online.de (Jan Wieck) Message-Id: <200007071947.VAA26359@hot.jw.home> Subject: Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios... In-Reply-To: from "eisentrp@csis.gvsu.edu" at "Jul 7, 2000 09:14:07 am" To: Peter Eisentraut Date: Fri, 7 Jul 2000 21:47:10 +0200 (MEST) CC: Jan Wieck , Tom Lane , PostgreSQL HACKERS Reply-To: Jan Wieck X-Mailer: ELM [version 2.4ME+ PL68 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Sender: 340000654369-0001@t-dialin.net X-Archive-Number: 200007/455 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 #