From: Magnus Hagander <magnus@hagander.net>
To: Mikkel Høgh <mikkel@hoegh.org>
Cc: pgsql-general@postgresql.org
Subject: Re: Drupal and PostgreSQL - performance issues?
Date: Tue, 14 Oct 2008 21:17:39 +0200
Message-ID: <48F4F053.1060201@hagander.net> (raw)
In-Reply-To: <C6449FCD-198D-4A04-BACB-1BB2F20DD5B1@hoegh.org>
References: <a93e6cbe-0000-4000-9a34-4db3620c619d@mm>
<C6449FCD-198D-4A04-BACB-1BB2F20DD5B1@hoegh.org>
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
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: magnus@hagander.net, mikkel@hoegh.org, pgsql-general@postgresql.org
Subject: Re: Drupal and PostgreSQL - performance issues?
In-Reply-To: <48F4F053.1060201@hagander.net>
* 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