Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 1ECDB2E0100 for ; Tue, 12 Feb 2008 13:46:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 73508-05 for ; Tue, 12 Feb 2008 13:46:35 -0400 (AST) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171]) by postgresql.org (Postfix) with ESMTP id A3F562E00FC for ; Tue, 12 Feb 2008 13:46:53 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id j3so531439ugf.49 for ; Tue, 12 Feb 2008 09:46:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=rxI0KVdaQPq0g043KfSo3k0Jo0FsuBRTA3q43HHu4B8=; b=PSwPkrNm8bUrL5chN4buGfFcoE55JM/OrgupH0MbXZeEyGqurt/nxd/sAQpLTr9tHFpYs7l9R7R6CKEhqKZIXfRdwgC2dt93bNVp1iXQsKkfEuCILBLqlYd3yyFY5pLX3HelPUDEJwx/7WF6g+AuYe1NZgZyK/oFiVqdDpPQvFA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Ue5cdElbZg12N+sa4Cc1YfBxMHABJlE/d9okgzgz8iMCt+KJGMKJqf2YNuoj5nK7uQ02R2dz81LvvxzWfIfbhAV1CtJinJ5ZAIhygI3dB2DIO68D80HUduvo2X+3DXTnyjyrQ8XNc+iajisCiTdMNY3udxMHRreQfl7Ji/uahHw= Received: by 10.78.136.9 with SMTP id j9mr2962771hud.46.1202838412193; Tue, 12 Feb 2008 09:46:52 -0800 (PST) Received: by 10.78.143.4 with HTTP; Tue, 12 Feb 2008 09:46:52 -0800 (PST) Message-ID: Date: Tue, 12 Feb 2008 10:46:52 -0700 From: "=?ISO-8859-1?Q?fabrix_pe=F1uelas?=" To: "Michael Fuhr" Subject: Re: Questions about enabling SSL Cc: pgsql-performance@postgresql.org In-Reply-To: <20080212010012.GA42187@winnie.fuhr.org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_13237_18707407.1202838412196" References: <20080212003751.GA42006@winnie.fuhr.org> <20080212010012.GA42187@winnie.fuhr.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/119 X-Sequence-Number: 28661 ------=_Part_13237_18707407.1202838412196 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Thanks Michael... 2008/2/11, Michael Fuhr : > > On Mon, Feb 11, 2008 at 05:37:51PM -0700, Michael Fuhr wrote: > > On Mon, Feb 11, 2008 at 04:58:35PM -0700, fabrix pe=F1uelas wrote: > > > If ssl is enable in postgresql decreanse the performance of the > database? > > > How much? > > > > The performance impact of an encrypted connection depends on how > > expensive the queries are and how much data they return. > > Another consideration is how much time you spend using each connection > vs. how much time it takes to establish each connection. A thousand > simple queries over the same encrypted connection might be significantly > faster than running each query over a separate unencrypted connection, > which in turn will probably be significantly faster than using > separate encrypted connections that must each carry out a relatively > expensive key establishment. > > -- > Michael Fuhr > ------=_Part_13237_18707407.1202838412196 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Thanks Michael...

2008/2/11, Michae= l Fuhr <mike@fuhr.org>: On Mon, Feb 11, 2008 at 05:37:51PM -0700, Michael Fuhr wrote:
> On Mo= n, Feb 11, 2008 at 04:58:35PM -0700, fabrix pe=F1uelas wrote:
> > = If ssl is enable  in postgresql decreanse the performance of the = database?
> > How much?
>
> The performance impact of an encrypted = connection depends on how
> expensive the queries are and how much da= ta they return.

Another consideration is how much time you spend usi= ng each connection
vs. how much time it takes to establish each connection.  A thous= and
simple queries over the same encrypted connection might be significa= ntly
faster than running each query over a separate unencrypted connecti= on,
which in turn will probably be significantly faster than using
separate = encrypted connections that must each carry out a relatively
expensive ke= y establishment.

--
Michael Fuhr

------=_Part_13237_18707407.1202838412196--