Re: intel vs amd benchmark for pg server

From: Michael Loftis <mloftis(at)wgops(dot)com>
To: postgres(at)vrane(dot)com
Cc: "P(dot)J(dot) Josh Rovero" <rovero(at)sonalysts(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: intel vs amd benchmark for pg server
Date: 2002-04-26 18:38:06
Message-ID: 3CC99E8E.4070309@wgops.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)vrane(dot)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(at)vrane(dot)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(at)sonalysts(dot)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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-04-26 18:46:32 Re: icps, shmmax and shmall - Shared Memory tuning
Previous Message Tom Lane 2002-04-26 18:30:03 Re: requesting features in PostgreSQL