Thread: Re: [ADMIN] Benchmarking postgres on Solaris/Linux

Re: [ADMIN] Benchmarking postgres on Solaris/Linux

From
"Anjan Dave"
Date:
What bus speeds?
 
533MHz on the 32-bit Intel will give you about 4.2Gbps of IO throughput...
 
I think the Sun will be 150MHz, 64bit is 2.4Gbps of IO. Correct me if i am wrong.
 
Thanks,
Anjan

    -----Original Message----- 
    From: Subbiah, Stalin [mailto:SSubbiah@netopia.com] 
    Sent: Tue 3/23/2004 1:40 PM 
    To: 'Andrew Sullivan'; 'pgsql-performance@postgresql.org' 
    Cc: 
    Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux
    
    

    We are looking into Sun V210 (2 x 1 GHz cpu, 2 gig ram, 5.8Os) vs. Dell 1750
    (2 x 2.4 GHz xeon, 2 gig ram, RH3.0). database will mostly be
    write intensive and disks will be on raid 10. Wondering if 64bit 1 GHz to
    32bit 2.4 GHz make a big difference here.
    
    Thanks!
    
    -----Original Message-----
    From: pgsql-performance-owner@postgresql.org
    [mailto:pgsql-performance-owner@postgresql.org]On Behalf Of Andrew
    Sullivan
    Sent: Tuesday, March 23, 2004 9:37 AM
    To: 'pgsql-performance@postgresql.org'
    Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux
    
    
    On Mon, Mar 22, 2004 at 04:05:45PM -0800, Subbiah, Stalin wrote:
    > being the key performance booster for postgres.  what is the preferred OS
    > for postgres deployment if given an option between linux and solaris. As
    
    One thing this very much depends on is what you're trying to do.
    Suns have a reputation for greater reliability.  While my own
    experience with Sun hardware has been rather shy of sterling, I _can_
    say that it stands head and shoulders above a lot of the x86 gear you
    can get.
    
    If you're planning to use Solaris on x86, don't bother.  Solaris is a
    slow, bloated pig compared to Linux, at least when it comes to
    managing the largish number of processes that Postgres requires.
    
    If pure speed is what you're after, I have found that 2-way, 32 bit
    Linux on P-IIIs compares very favourably to 4 way 64 bit Ultra SPARC
    IIs.
    
    A
    
    --
    Andrew Sullivan  | ajs@crankycanuck.ca
    The fact that technology doesn't work is no bar to success in the
    marketplace.
                    --Philip Greenspun
    
    ---------------------------(end of broadcast)---------------------------
    TIP 2: you can get off all lists at once with the unregister command
        (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
    
    ---------------------------(end of broadcast)---------------------------
    TIP 9: the planner will ignore your desire to choose an index scan if your
          joining column's datatypes do not match