Re: [ADMIN] Benchmarking postgres on Solaris/Linux - Mailing list pgsql-performance

From Vivek Khera
Subject Re: [ADMIN] Benchmarking postgres on Solaris/Linux
Date
Msg-id x7k71a9nv6.fsf@yertle.int.kciLink.com
Whole thread Raw
In response to Re: [ADMIN] Benchmarking postgres on Solaris/Linux  ("Subbiah, Stalin" <SSubbiah@netopia.com>)
List pgsql-performance
>>>>> "SS" == Stalin Subbiah <Subbiah> writes:

SS> We are looking into Sun V210 (2 x 1 GHz cpu, 2 gig ram, 5.8Os)
SS> vs. Dell 1750 (2 x 2.4 GHz xeon, 2 gig ram, RH3.0). database will
SS> mostly be write intensive and disks will be on raid 10. Wondering
SS> if 64bit 1 GHz to 32bit 2.4 GHz make a big difference here.

Spend all your money speeding up your disk system.  If you're mostly
writing (like my main app) then that's your bottleneck.  I use a dell
2650 with external RAID 5 on 14 spindles.  I didn't need that much
disk space, but went for  maxing out the number of spindles.  RAID 5
was faster than RAID10 or RAID50 with this configuration for me.


--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD  +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Help with query plan inconsistencies
Next
From: pginfo
Date:
Subject: Re: slow vacuum performance