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
>
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 |