Re: Questions about enabling SSL - Mailing list pgsql-performance

From Michael Fuhr
Subject Re: Questions about enabling SSL
Date
Msg-id 20080212010012.GA42187@winnie.fuhr.org
Whole thread Raw
In response to Re: Questions about enabling SSL  (Michael Fuhr <mike@fuhr.org>)
Responses Re: Questions about enabling SSL  ("fabrix peñuelas" <fabrixio1@gmail.com>)
List pgsql-performance
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ñuelas 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

pgsql-performance by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Questions about enabling SSL
Next
From: Michael Fuhr
Date:
Subject: Re: Question about CLUSTER