Received: from acheron.rime.com.au (root@albatr.lnk.telstra.net [139.130.54.222]) by hub.org (8.10.1/8.10.1) with ESMTP id e6831TW43221 for ; Fri, 7 Jul 2000 23:01:29 -0400 (EDT) Received: from oberon (Oberon.rime.com.au [203.8.195.100]) by acheron.rime.com.au (8.9.3/8.9.3) with SMTP id MAA15332; Sat, 8 Jul 2000 12:48:57 +1000 Message-Id: <3.0.5.32.20000708125646.02bf9aa0@mail.rhyme.com.au> X-Sender: pjw@mail.rhyme.com.au X-Mailer: QUALCOMM Windows Eudora Pro Version 3.0.5 (32) Date: Sat, 08 Jul 2000 12:56:46 +1000 To: Tom Lane From: Philip Warner Subject: Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios... Cc: Bruce Momjian , Jan Wieck , Peter Eisentraut , PostgreSQL HACKERS In-Reply-To: <22942.963023281@sss.pgh.pa.us> References: <3.0.5.32.20000708120031.00ce8100@mail.rhyme.com.au> <200007080119.VAA14375@candle.pha.pa.us> <200007080119.VAA14375@candle.pha.pa.us> <3.0.5.32.20000708120031.00ce8100@mail.rhyme.com.au> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Archive-Number: 200007/480 At 22:28 7/07/00 -0400, Tom Lane wrote: > >pg_dump is rather a different case. I would want to see a runtime >option *not* to use compression That's there already; using -Z0 produces the same output as a mchine without zlib. >But making an uncompressed dump today doesn't invalidate >the compressed dump you made yesterday, nor vice versa. Not sure what you mean here. >Good point. If we include zlib in the distribution it would be pretty >silly for pg_dump not to use it. If we don't, then Peter's remarks >about not liking an environment-determined feature set are relevant. zlib seems to have been ported to zillions of architectures (must be a good design ;-}), so it's probably pretty safe to put in the source tree, and I'm sure any porting problems we encounter would be useful to the zlib maintainers. If we don't want to use zlib, then fefore using Jan's compression code in pg_dump, I suppose I'd need to know that the output is compatible across 32/64 bit architectures and is not sensitive to other issues like endian-ness. ---------------------------------------------------------------- Philip Warner | __---_____ Albatross Consulting Pty. Ltd. |----/ - \ (A.C.N. 008 659 498) | /(@) ______---_ Tel: (+61) 0500 83 82 81 | _________ \ Fax: (+61) 0500 83 82 82 | ___________ | Http://www.rhyme.com.au | / \| | --________-- PGP key available upon request, | / and from pgp5.ai.mit.edu:11371 |/