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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
