Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C22982E2E00 for ; Mon, 11 Feb 2008 20:38:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 71215-02 for ; Mon, 11 Feb 2008 20:38:01 -0400 (AST) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by postgresql.org (Postfix) with ESMTP id 8D3232E0333 for ; Mon, 11 Feb 2008 20:38:01 -0400 (AST) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.8/8.13.8) with ESMTP id m1C0brup066795 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Mon, 11 Feb 2008 17:37:57 -0700 (MST) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.14.2/8.14.2) with ESMTP id m1C0bq2e042094; Mon, 11 Feb 2008 17:37:52 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.14.2/8.14.2/Submit) id m1C0bqRs042093; Mon, 11 Feb 2008 17:37:52 -0700 (MST) (envelope-from mfuhr) Date: Mon, 11 Feb 2008 17:37:51 -0700 From: Michael Fuhr To: fabrix =?iso-8859-1?Q?pe=F1uelas?= Cc: pgsql-performance@postgresql.org Subject: Re: Questions about enabling SSL Message-ID: <20080212003751.GA42006@winnie.fuhr.org> References: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/109 X-Sequence-Number: 28651 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