Re: Drupal and PostgreSQL - performance issues?

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: Drupal and PostgreSQL - performance issues?
Дата
Msg-id 48F4F053.1060201@hagander.net
обсуждение исходный текст
Ответ на Re: Drupal and PostgreSQL - performance issues?  (Mikkel Høgh <mikkel@hoegh.org>)
Ответы Re: Drupal and PostgreSQL - performance issues?
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Drupal and PostgreSQL - performance issues?
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: databases list to file