From: Michael Fuhr <mike@fuhr.org>
To: fabrix peñuelas <fabrixio1@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Questions about enabling SSL
Date: Mon, 11 Feb 2008 18:00:13 -0700
Message-ID: <20080212010012.GA42187@winnie.fuhr.org> (raw)
In-Reply-To: <20080212003751.GA42006@winnie.fuhr.org>
References: <dedbc5820802111558h69a0a6a3x7b6d5eeece6f5024@mail.gmail.com>
<20080212003751.GA42006@winnie.fuhr.org>
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
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-performance@postgresql.org
Cc: mike@fuhr.org, fabrixio1@gmail.com
Subject: Re: Questions about enabling SSL
In-Reply-To: <20080212010012.GA42187@winnie.fuhr.org>
* 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