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

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

From: Scott Carey <scott(at)richrelevance(dot)com>
To: Greg Smith <greg(at)2ndquadrant(dot)com>
Cc: Philippe Rimbault <primbault(at)edd(dot)fr>, "pgsql-performance(at)postgresql(dot)org"<pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance on new 64bit server compared to my 32bit desktop
Date: 2010-08-27 04:30:58
Message-ID: E613263E-09D5-4562-BBAF-C72B09883E26@richrelevance.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Aug 19, 2010, at 11:25 AM, Greg Smith wrote:

> Philippe Rimbault wrote:
>> I've run "time pgbench -c 50" :
>>    server x64 :
>>        starting vacuum...end.
>>        transaction type: TPC-B (sort of)
>>        scaling factor: 1
>>        query mode: simple
>>        number of clients: 50
>>        number of transactions per client: 10
>>        number of transactions actually processed: 500/500
>>        tps = 523.034437 (including connections establishing)
>>        tps = 663.511008 (excluding connections establishing)
>> 
> 
> As mentioned already, most of the difference you're seeing is simply 
> that your desktop system has faster individual processor cores in it, so 
> jobs where only a single core are being used are going to be faster on it.
> 

But the select count(*) query, cached in RAM is 3x faster in one system than the other.  The CPUs aren't 3x different performance wise.  Something else may be wrong here.

An individual Core2 Duo 2.93Ghz should be at most 50% faster than a 2.2Ghz Opteron for such a query.   Unless there are some compile options that are set wrong.   I would check the compile options.



In response to

Responses

pgsql-performance by date

Next:From: Magnus HaganderDate: 2010-08-27 07:54:46
Subject: Re: [Fwd: postgres 8.4.1 number of connections]
Previous:From: Josh BerkusDate: 2010-08-27 01:05:57
Subject: Re: [Fwd: postgres 8.4.1 number of connections]

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