Re: [GENERAL] Drupal and PostgreSQL - performance issues?

[Mikkel Høgh]

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

--
Kind regards,

Mikkel Høgh <[EMAIL PROTECTED]>

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.

for your test.

So you might want to check if setting ssl to false makes a difference

Ouch, there's a gotcha. So enabling SSL gives you SSL connections by
default, even for localhost? That’s… unexpected.

refuse all SSL connections.


//Magnus

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Yes. To avoid it, specify "hostnossl" in the pg_hba.conf file.That will

smime.p7s
Description: S/MIME cryptographic signature