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

2008-10-13 Thread Scott Marlowe
On Mon, Oct 13, 2008 at 8:19 AM, Scott Marlowe <[EMAIL PROTECTED]> wrote: > There was a time when Microsoft was trying to cast IIS as faster than > Apache, so they released a benchmark showing IIS being twice as fast > as apache at delivering static pages. Let's say it was 10mS for > apache and 2

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

2008-10-13 Thread Scott Marlowe
On Mon, Oct 13, 2008 at 12:00 AM, Mikkel Høgh <[EMAIL PROTECTED]> wrote: > Alright, my benchmarks might have been a bit naïve. > When it comes to hardware, my webserver is a SunFire X2100 with an Opteron > 1210 Dual Core and 4 GB DDR2 RAM, running 64-bit Ubuntu Linux Server 8.04 > LTS. > > When it

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

2008-10-13 Thread Ang Chin Han
On Mon, Oct 13, 2008 at 11:57 AM, Mikkel Høgh <[EMAIL PROTECTED]> wrote: > In any case, if anyone has any tips, input, etc. on how best to configure > PostgreSQL for Drupal, or can find a way to poke holes in my analysis, I > would love to hear your insights :) It'd be more accurate to configure

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

2008-10-12 Thread Mikkel Høgh
Alright, my benchmarks might have been a bit naïve. When it comes to hardware, my webserver is a SunFire X2100 with an Opteron 1210 Dual Core and 4 GB DDR2 RAM, running 64-bit Ubuntu Linux Server 8.04 LTS. When it comes to the resource usage section of my postgresql.conf, the only thing th

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

2008-10-12 Thread Stephen Frost
* Mikkel Høgh ([EMAIL PROTECTED]) wrote: > I have been testing it a bit performance-wise, and the numbers are > worrying. In my test, MySQL (using InnoDB) had a 40% lead in > performance, but I'm unsure whether this is indicative for PostgreSQL > performance in general or perhaps a misconfigu

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

2008-10-12 Thread Scott Marlowe
On Sun, Oct 12, 2008 at 9:57 PM, Mikkel Høgh <[EMAIL PROTECTED]> wrote: > Hi there, > > I've been toying with using PostgreSQL for some of my Drupal sites for some > time, and after his session at OpenSourceDays in Copenhagen last weekend, > Magnus Hagander told me that there a quite a few in the P