From: ktm@rice.edu <ktm@rice.edu>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: Florian Pflug <fgp@phlo.org>
Cc: Magnus Hagander <magnus@hagander.net>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Euler Taveira <euler@timbira.com>
Cc: Pgsql Hackers <pgsql-hackers@postgresql.org>
Subject: Re: libpq compression
Date: Fri, 15 Jun 2012 09:10:36 -0500
Message-ID: <20120615141036.GG6547@aart.rice.edu> (raw)
In-Reply-To: <CAHyXU0wF9oDrMJgarH36V7sCv-iOuXLui1u-ar0eMwUUAXp6sw@mail.gmail.com>
References: <4FD9698F.2090407@timbira.com>
<29853.1339651170@sss.pgh.pa.us>
<4FD9E70B.9040607@timbira.com>
<11502.1339699384@sss.pgh.pa.us>
<20120615021938.GA21704@momjian.us>
<CABUevEyv4T+1gR6_Uqm_1qUD9PNDg6UdXbJhwHZgFi9hpQQ6NQ@mail.gmail.com>
<F3B8BAA6-23E9-423A-A7D1-D2E14769F326@phlo.org>
<CABUevExi-cJ6AvF2kDOy+qQsB+0JHofrcvVmNVoJ2HziZMMaAg@mail.gmail.com>
<22690C61-E960-4A2A-BFD5-DAD3D3B5C474@phlo.org>
<CAHyXU0wF9oDrMJgarH36V7sCv-iOuXLui1u-ar0eMwUUAXp6sw@mail.gmail.com>
On Fri, Jun 15, 2012 at 07:18:34AM -0500, Merlin Moncure wrote:
> On Fri, Jun 15, 2012 at 5:48 AM, Florian Pflug <fgp@phlo.org> wrote:
> > On Jun15, 2012, at 12:09 , Magnus Hagander wrote:
> >> On Fri, Jun 15, 2012 at 5:52 PM, Florian Pflug <fgp@phlo.org> wrote:
> >>> On Jun15, 2012, at 07:50 , Magnus Hagander wrote:
> >>>> Second, we also have things like the JDBC driver and the .Net driver
> >>>> that don't use libpq. the JDBC driver uses the native java ssl
> >>>> support, AFAIK. Does that one support the compression, and does it
> >>>> support controlling it?
> >>>
> >>> Java uses pluggable providers with standardized interfaces for most
> >>> things related to encryption. SSL support is provided by JSSE
> >>> (Java Secure Socket Extension). The JSSE implementation included with
> >>> the oracle JRE doesn't seem to support compression according to the
> >>> wikipedia page quoted above. But chances are that there exists an
> >>> alternative implementation which does.
> >>
> >> Yeah, but that alone is IMO a rather big blocker for claiming that
> >> this is the only way to do it :( And I think the fact that that
> >> wikipedia page doesn't list any other ones, is a sign that there might
> >> not be a lot of other choices out there in reality - expecially not
> >> opensource…
> >
> > Hm, but things get even harder for the JDBC and .NET folks if we go
> > with a third-party compression method. Or would we require that the
> > existence of a free Java (and maybe .NET) implementation of such a
> > method would be an absolute must?
> >
> > The way I see it, if we use SSL-based compression then non-libpq clients
> > there's at least a chance of those clients being able to use it easily
> > (if their SSL implementation supports it). If we go with a third-party
> > compression method, they *all* need to add yet another dependency, or may
> > even need to re-implement the compression method in their implementation
> > language of choice.
>
> hm, that's a really excellent point.
>
> merlin
>
I agree and think that the SSL-based compression is an excellent default
compression scheme. The plugable compression approach allows for the
choice of the most appropriate compression implementation based on the
application needs. It really addresses corner cases such as high-
performance system.
Regards,
Ken
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: ktm@rice.edu, mmoncure@gmail.com, fgp@phlo.org, magnus@hagander.net, bruce@momjian.us, tgl@sss.pgh.pa.us, euler@timbira.com
Subject: Re: libpq compression
In-Reply-To: <20120615141036.GG6547@aart.rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox