pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedQuestions about enabling SSL
4+ messages / 2 participants
[nested] [flat]
* Questions about enabling SSL
@ 2008-02-11 23:58 fabrix peñuelas <fabrixio1@gmail.com>
2008-02-12 00:37 ` Re: Questions about enabling SSL Michael Fuhr <mike@fuhr.org>
0 siblings, 1 reply; 4+ messages in thread
From: fabrix peñuelas @ 2008-02-11 23:58 UTC (permalink / raw)
To: pgsql-performance
Hi all...
If ssl is enable in postgresql decreanse the performance of the database?
How much?
Thanks in advance
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Questions about enabling SSL
2008-02-11 23:58 Questions about enabling SSL fabrix peñuelas <fabrixio1@gmail.com>
@ 2008-02-12 00:37 ` Michael Fuhr <mike@fuhr.org>
2008-02-12 01:00 ` Re: Questions about enabling SSL Michael Fuhr <mike@fuhr.org>
0 siblings, 1 reply; 4+ messages in thread
From: Michael Fuhr @ 2008-02-12 00:37 UTC (permalink / raw)
To: fabrix peñuelas <fabrixio1@gmail.com>; +Cc: pgsql-performance
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. A query
that joins several tables and aggregates millions of rows might
take several seconds or minutes to run and return only a few rows;
for such a query the impact of an encrypted connection is insignificant.
But if you make many queries that run quickly and return large
result sets then you might indeed notice the impact of an encrypted
connection vs. a non-encrypted connection. The most reliable way
to assess the impact would be to run representative queries over
your data and measure the difference yourself.
--
Michael Fuhr
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Questions about enabling SSL
2008-02-11 23:58 Questions about enabling SSL fabrix peñuelas <fabrixio1@gmail.com>
2008-02-12 00:37 ` Re: Questions about enabling SSL Michael Fuhr <mike@fuhr.org>
@ 2008-02-12 01:00 ` Michael Fuhr <mike@fuhr.org>
2008-02-12 17:46 ` Re: Questions about enabling SSL fabrix peñuelas <fabrixio1@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Michael Fuhr @ 2008-02-12 01:00 UTC (permalink / raw)
To: fabrix peñuelas <fabrixio1@gmail.com>; +Cc: 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Questions about enabling SSL
2008-02-11 23:58 Questions about enabling SSL fabrix peñuelas <fabrixio1@gmail.com>
2008-02-12 00:37 ` Re: Questions about enabling SSL Michael Fuhr <mike@fuhr.org>
2008-02-12 01:00 ` Re: Questions about enabling SSL Michael Fuhr <mike@fuhr.org>
@ 2008-02-12 17:46 ` fabrix peñuelas <fabrixio1@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: fabrix peñuelas @ 2008-02-12 17:46 UTC (permalink / raw)
To: Michael Fuhr <mike@fuhr.org>; +Cc: pgsql-performance
Thanks Michael...
2008/2/11, Michael Fuhr <mike@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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2008-02-12 17:46 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-11 23:58 Questions about enabling SSL fabrix peñuelas <fabrixio1@gmail.com>
2008-02-12 00:37 ` Michael Fuhr <mike@fuhr.org>
2008-02-12 01:00 ` Michael Fuhr <mike@fuhr.org>
2008-02-12 17:46 ` fabrix peñuelas <fabrixio1@gmail.com>
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