Re: Drupal and PostgreSQL - performance issues?

[Mikkel Høgh <mikkel@xxxxxxxxx>]

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@xxxxxxxxx>

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@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

<<attachment: smime.p7s>>