Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id C0C64CE6EC for ; Fri, 15 Jun 2012 12:24:28 -0300 (ADT) Received: from exprod7og127.obsmtp.com ([64.18.2.210]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SfYNu-0003sX-Ld for pgsql-hackers@postgresql.org; Fri, 15 Jun 2012 15:24:28 +0000 Received: from mail-lb0-f171.google.com ([209.85.217.171]) (using TLSv1) by exprod7ob127.postini.com ([64.18.6.12]) with SMTP ID DSNKT9tTnbDvJVgRAZyYoeob4t90BADY6QCF@postini.com; Fri, 15 Jun 2012 08:24:26 PDT Received: by lbom4 with SMTP id m4so6336130lbo.16 for ; Fri, 15 Jun 2012 08:24:12 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding :x-gm-message-state; bh=URiP8XeTAIFGRh+8FGTad1AlqY409JOYeP+ghc5QlvU=; b=Q/BDx+O6ui3aJKFBnEA8pRW0GbFWy015ryhdoRARmgup2YJdsZzlThFWua0GOZ2wTO PRSIcAPCuTlsLIqHnl2clJ0VP0SSj4ehvLOU+donVooaZp+zKvRqnsWGwd5Mydycxlna 2bslGZyzYK8++gESEXzwm5BeIlPOjF9PUxdkEsEN6WRQ65Aq3c3PcfTeV6NIs4ohHvHo SVzTMwZH/zjfZhLo5ZzX4oL/P87RzG/0XQfwQVf3fpKHvzpjpYw+1iY8vlMIIH2bEWxX LJ7CLPD8n8a/R+4oN+4v+9KRz+hGpJVeDscA2BtqR5LNUaUpLwup9cR+fXXTZwVk0F7D SiDw== Received: by 10.152.108.38 with SMTP id hh6mr473205lab.28.1339773851832; Fri, 15 Jun 2012 08:24:11 -0700 (PDT) Received: from [192.168.1.100] (dsl-hkibrasgw2-ff6cc300-200.dhcp.inet.fi. [88.195.108.200]) by mx.google.com with ESMTPS id jj5sm12888967lab.1.2012.06.15.08.24.09 (version=TLSv1/SSLv3 cipher=OTHER); Fri, 15 Jun 2012 08:24:10 -0700 (PDT) Message-ID: <4FDB5396.4050402@enterprisedb.com> Date: Fri, 15 Jun 2012 18:24:06 +0300 From: Heikki Linnakangas User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:10.0.4) Gecko/20120510 Icedove/10.0.4 MIME-Version: 1.0 To: Magnus Hagander CC: Florian Pflug , Bruce Momjian , Tom Lane , Euler Taveira , Pgsql Hackers Subject: Re: libpq compression 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> <22690C61-E960-4A2A-BFD5-DAD3D3B5C474@phlo.org> <4FDB4D0F.6090206@enterprisedb.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Gm-Message-State: ALoCoQm2VABvpSBw5tGhBAr4qrNVDjf73zN6vFMva95+0Ra+LBFVFifdGfM/VD8kG4rP1XQhsC2o X-Pg-Spam-Score: -4.2 (----) X-Archive-Number: 201206/724 X-Sequence-Number: 209564 On 15.06.2012 17:58, Magnus Hagander wrote: > On Fri, Jun 15, 2012 at 10:56 PM, Heikki Linnakangas > wrote: >> On 15.06.2012 17:39, Magnus Hagander wrote: >>> >>> On Fri, Jun 15, 2012 at 6:48 PM, Florian Pflug wrote: >>>> >>>> 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. >>> >>> I only partially agree. If there *is* no third party SSL libary that >>> does support it, then they're stuck reimplementing an *entire SSL >>> library*, which is surely many orders of magnitude more work, and >>> suddenly steps into writing encryption code which is a lot more >>> sensitive. >> >> You could write a dummy SSL implementation that only does compression, not >> encryption. Ie. only support the 'null' encryption method. That should be >> about the same amount of work as writing an implementation of compression >> using whatever protocol we would decide to use for negotiating the >> compression. > > Sure, but then what do you do if you actually want both? Umm, then you use a real SSL libray, not the dummy one? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com