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

From: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Jan Wieck <JanWieck(at)Yahoo(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL HACKERS <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...
Date: 2000-07-08 02:56:46
Message-ID: 3.0.5.32.20000708125646.02bf9aa0@mail.rhyme.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-sql

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 |/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message omid omoomi 2000-07-08 04:14:57 Re: Couple of design questions
Previous Message Tom Lane 2000-07-08 02:28:01 Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...

Browse pgsql-hackers by date

  From Date Subject
Next Message Chris Bitmead 2000-07-08 03:02:39 Re: libpq / SQL3
Previous Message Tom Lane 2000-07-08 02:56:06 Re: libpq / SQL3

Browse pgsql-sql by date

  From Date Subject
Next Message Tony Nakamura 2000-07-08 03:35:04 Supported Encoding
Previous Message Tom Lane 2000-07-08 02:28:01 Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...