Re: Performance on new 64bit server compared to my 32bit desktop - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Performance on new 64bit server compared to my 32bit desktop
Date
Msg-id AANLkTi=tFpkDkcJy0nsdMLTwUwYDfiuNq5+RD_2vcYh_@mail.gmail.com
Whole thread Raw
In response to Performance on new 64bit server compared to my 32bit desktop  (Philippe Rimbault <primbault@edd.fr>)
Responses Re: Performance on new 64bit server compared to my 32bit desktop  (Philippe Rimbault <primbault@edd.fr>)
List pgsql-performance
On Thu, Aug 19, 2010 at 2:07 AM, Philippe Rimbault <primbault@edd.fr> wrote:
> Hi,
>
> I'm having a strange performance result on a new database server compared to
> my simple desktop.
>
> The configuration of the new server :
>    - OS : GNU/Linux Debian Etch x86_64
>    - kernel : Linux 2.6.26-2-vserver-amd64 #1 SMP Sun Jun 20 20:40:33 UTC
> 2010 x86_64 GNU/Linux
>        (tests are on the "real server", not on a vserver)
>    - CPU : 2 x Six-Core AMD Opteron(tm) Processor 2427 @ 2.20GHz
>    - RAM : 32 Go
> The configuration of my desktop pc :
>    - OS : GNU/Linux Debian Testing i686
>    - kernel : Linux 2.6.32-5-686 #1 SMP Tue Jun 1 04:59:47 UTC 2010 i686
> GNU/Linux
>    - CPU : Intel(R) Core(TM)2 Duo CPU     E7500  @ 2.93GHz
>    - RAM : 2 Go

PERFORMANCE STUFF DELETED FOR BREVITY

> Do you think it's a 32bit/64bit difference ?

No, it's likely that your desktop has much faster CPU cores than your
server, and it has drives that may or may not be obeying fsync
commands.  Your server, OTOH, has more cores, so it's likely to do
better under a real load.  And assuming it has more disks on a better
controller it will also do better under heavier loads.

So how are the disks setup anyway?

pgsql-performance by date:

Previous
From: Philippe Rimbault
Date:
Subject: Performance on new 64bit server compared to my 32bit desktop
Next
From: Philippe Rimbault
Date:
Subject: Re: Performance on new 64bit server compared to my 32bit desktop