Skip site navigation (1) Skip section navigation (2)

Re: Performance on new 64bit server compared to my 32bit desktop

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Philippe Rimbault <primbault(at)edd(dot)fr>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance on new 64bit server compared to my 32bit desktop
Date: 2010-08-19 09:51:02
Message-ID: AANLkTi=tFpkDkcJy0nsdMLTwUwYDfiuNq5+RD_2vcYh_@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, Aug 19, 2010 at 2:07 AM, Philippe Rimbault <primbault(at)edd(dot)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?

In response to

Responses

pgsql-performance by date

Next:From: Philippe RimbaultDate: 2010-08-19 10:23:17
Subject: Re: Performance on new 64bit server compared to my 32bit desktop
Previous:From: Philippe RimbaultDate: 2010-08-19 08:07:41
Subject: Performance on new 64bit server compared to my 32bit desktop

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group