Re: intel vs amd benchmark for pg server - Mailing list pgsql-general

From Steve Wampler
Subject Re: intel vs amd benchmark for pg server
Date
Msg-id 3CC96430.CA63C0C8@noao.edu
Whole thread Raw
In response to intel vs amd benchmark for pg server  (postgres@vrane.com)
List pgsql-general
postgres@vrane.com wrote:
>
> 1. 64MB machines beat 192MB and 240MB machies.
>
> 2. On 64 MB machine I tested on 5400rpm drive
>         and still much faster than athlon machine.
>
> 3. On sis machine I am using a separete ati agp card
>         not the built in one and as a result
>         i am using all memory.
>
> You would expect AMD machines to be at least
> slightly faster because cpu speed ratio are
> about 2 or bigger.   You might not expect
> linear scaling but at least faster you know.
>
> Also as I said kernel compilation time
> scales almost linearly with cpu speed

Have you also run other tests to check out the
non-cpu parts of the two systems?  If kernel
compiles (reasonably CPU intensive) scale with
CPU speed, then the odds are pretty good that
it's not the CPU that's slowing down your
DB tests.  Try timing disk accesses with hdparm,
for example - this may be a disk controller
issue.

I'm assuming you've got postgres configured
appropriately for both machines, of course.

--
Steve Wampler -- swampler@noao.edu
O sibile, si ergo.  Fortibus es enaro.
Nobile, demis trux.  Demis phulla causan dux.

pgsql-general by date:

Previous
From: postgres@vrane.com
Date:
Subject: Re: intel vs amd benchmark for pg server
Next
From: Tom Lane
Date:
Subject: Re: pid gets overwritten in OSX