Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 22CBACE6F0 for ; Fri, 15 Jun 2012 12:59:15 -0300 (ADT) Received: from mail-qc0-f174.google.com ([209.85.216.174]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SfYvZ-0004R6-36 for pgsql-hackers@postgresql.org; Fri, 15 Jun 2012 15:59:14 +0000 Received: by qcro28 with SMTP id o28so1741620qcr.19 for ; Fri, 15 Jun 2012 08:59:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=date:from:to:cc:subject:message-id:references:mime-version :content-type:content-disposition:content-transfer-encoding :in-reply-to:user-agent; bh=H1ZYJEJAOt9uUzaW2DUJS8TNgbukM1uJwqzC/3xlbeE=; b=unyFNOH8S5Cag+/ElDnvTIE+/UaEtBvPIjjW7oiFS5kbYA4H4c/M77U8GmjKOJndwr 8ob5tVtE+JrbRCKHutB8YFIUsI9+ytWmWyUf8lsYbZErvskkL66njbtY5xHpQWJbAxSk pFxHqzVfE8YHSccW6kKNNddG6EYGBb6yhF5MjsnJ1npDJEk+KE4oqa0wlJrlqvsA40gn RNBXddu9Sh4GSVXBLNIh6YDGjL+tGMeHpfvP5MJbvn5op/Y41Nu1Dh35UWlxQtmTVMHn FacYFHwgn/N9wGg8B//SDk0NFdGq6vQMwj0a40nC0bacR5c9Q6R8bYDct+DzO0B8dKkj bDgw== Received: by 10.224.213.196 with SMTP id gx4mr978142qab.23.1339775940135; Fri, 15 Jun 2012 08:59:00 -0700 (PDT) Received: from llserver.lakeliving.com (ool-18bbd2c6.static.optonline.net. [24.187.210.198]) by mx.google.com with ESMTPS id fc4sm23155103qab.21.2012.06.15.08.58.57 (version=TLSv1/SSLv3 cipher=OTHER); Fri, 15 Jun 2012 08:58:58 -0700 (PDT) Date: Fri, 15 Jun 2012 11:58:55 -0400 From: Ryan Kelly To: Magnus Hagander Cc: Heikki Linnakangas , Florian Pflug , Bruce Momjian , Tom Lane , Euler Taveira , Pgsql Hackers Subject: Re: libpq compression Message-ID: <20120615155855.GD319@llserver.lakeliving.com> References: <20120615021938.GA21704@momjian.us> <22690C61-E960-4A2A-BFD5-DAD3D3B5C474@phlo.org> <4FDB4D0F.6090206@enterprisedb.com> <4FDB5396.4050402@enterprisedb.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -2.3 (--) X-Archive-Number: 201206/728 X-Sequence-Number: 209568 On Fri, Jun 15, 2012 at 11:28:48PM +0800, Magnus Hagander wrote: > On Fri, Jun 15, 2012 at 11:24 PM, Heikki Linnakangas > wrote: > > 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? > > But (in this scenario, and so far nobody has proven it to be wrong) > there exists no real SSL library that does support compression. gnutls and openssl both support compression: http://www.gnu.org/software/gnutls/manual/html_node/Compression-algorithms-used-in-the-record-layer.html http://www.openssl.org/docs/apps/enc.html -Ryan Kelly > > -- >  Magnus Hagander >  Me: http://www.hagander.net/ >  Work: http://www.redpill-linpro.com/ > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers