Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2D78364FDB5 for ; Tue, 14 Oct 2008 16:17:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 16363-07 for ; Tue, 14 Oct 2008 16:17:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from svr2.hagander.net (svr2.hagander.net [88.198.128.226]) by postgresql.org (Postfix) with ESMTP id 3A82B64FD91 for ; Tue, 14 Oct 2008 16:17:42 -0300 (ADT) Received: from dynamic.hagander.net ([127.0.0.1]) (encrypted and authenticated) by svr2.hagander.net (Postfix) with ESMTP id 86946DCCC1F; Tue, 14 Oct 2008 21:17:40 +0200 (CEST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by mha-laptop.hagander.net (Postfix) with ESMTP id 148EF1241F9; Tue, 14 Oct 2008 21:17:40 +0200 (CEST) Message-ID: <48F4F053.1060201@hagander.net> Date: Tue, 14 Oct 2008 21:17:39 +0200 From: Magnus Hagander User-Agent: Thunderbird 2.0.0.17 (X11/20080925) MIME-Version: 1.0 To: =?windows-1252?Q?Mikkel_H=F8gh?= CC: pgsql-general@postgresql.org Subject: Re: Drupal and PostgreSQL - performance issues? References: In-Reply-To: X-Enigmail-Version: 0.95.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200810/566 X-Sequence-Number: 138815 Mikkel Høgh wrote: > On 14/10/2008, at 20.23, Daniel Verite wrote: >> What I've noticed on drupal-6.4 with Ubuntu 8.04 is that the default >> postgresql.conf has: >> ssl=true >> and since drupal doesn't allow connecting to pgsql with unix socket >> paths [1], what you get by default is probably TCP + SSL encryption. >> A crude test that just connects and disconnect to a local pg server >> appears to me to be 18 times faster when SSL is off. >> So you might want to check if setting ssl to false makes a difference >> for your test. > > Ouch, there's a gotcha. So enabling SSL gives you SSL connections by > default, even for localhost? That’s… unexpected. Yes. To avoid it, specify "hostnossl" in the pg_hba.conf file.That will refuse all SSL connections. //Magnus