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

From Michael Loftis
Subject Re: intel vs amd benchmark for pg server
Date
Msg-id 3CC99E8E.4070309@wgops.com
Whole thread Raw
In response to intel vs amd benchmark for pg server  (postgres@vrane.com)
List pgsql-general
Yes but you keep comparing apples and oranges.  Your benchmarks don't
mean hardly anything CPU speed wise because you've got so many other
variants.

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
>
>
>
>On Fri, Apr 26, 2002 at 09:49:31AM -0400, P.J. Josh Rovero wrote:
>
>>A fairer test would be to equip the machines with equivalent
>>disk (rpms and number) and RAM (amount and speed) configurations.
>>
>>SiS motherboards, particularly with on-board video, tend
>>to be lower performance than boards with separate AGP/PCI
>>video.
>>
>>postgres@vrane.com wrote:
>>
>>>Hi
>>>
>>>I would like to upgrade my production pg server from a machine with
>>>following specs
>>>    celeron 900MHz, intel 810 motherboard, 512MB
>>>    pc 133 sdram memory,
>>>    PGDATA is on 2 ide 7200rpm drives under software raid 1,
>>>    linux kernel 2.4.18
>>>
>>.
>>.
>>.
>>
>>>My workstation specs is amd 1.33GHz, 192MB SDRAM, SIS motherboard,
>>>$PGDATA is on a single 5400rpm drive.
>>>
>>--
>>P. J. "Josh" Rovero                                 Sonalysts, Inc.
>>Email: rovero@sonalysts.com    www.sonalysts.com    215 Parkway North
>>Work: (860)326-3671 or 442-4355                     Waterford CT 06385
>>***********************************************************************
>>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
>



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: requesting features in PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: icps, shmmax and shmall - Shared Memory tuning