Re: Drupal and PostgreSQL - performance issues?

After disabling SSL for localhost, I ran the tests again, and the
performance gap is reduced to about 30%.
--
Kind regards,

Mikkel Høgh <mikkel(at)hoegh(dot)org>

On 14/10/2008, at 21.17, Magnus Hagander wrote:

> 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
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general