Just an interesting comparison:
I don't have the specifics, but a  Dell 2 x 2.4GHZ/512KB L3 / 2GB RAM machine timed a 
query much faster than an older Sun E4000 with 6 x ~300MHZ CPUs / 2GB RAM. One on RH(8 
or 9, don't remember) and one on Solaris 9.
-----Original Message----- 
From: William Yu [mailto:[EMAIL PROTECTED] 
Sent: Tue 10/21/2003 12:12 PM 
Subject: Re: [PERFORM] PostgreSQL data on a NAS device ?

        > I have never worked with a XEON CPU before. Does anyone know how it performs
        > running PostgreSQL 7.3.4 / 7.4 on RedHat 9 ? Is it faster than a Pentium 4?
        > I believe the main difference is cache memory, right? Aside from cache mem,
        > it's basically a Pentium 4, or am I wrong?
        Well, see the problem is of course, there's so many flavors of P4s and
        Xeons that it's hard to tell which is faster unless you specify the
        exact model. And even then, it would depend on the workload. Would a
        Xeon/3GHz/2MB L3/400FSB be faster than a P4C/3GHz/800FSB? No idea as no
        one has complete number breakdowns on these comparisons. Oh yeah, you
        could get a big round number that says on SPEC or something one CPU is
        faster than the other but whether that's faster for Postgres and your PG
        app is a totally different story.
        That in mind, I wouldn't worry about it. The CPU is probably plenty fast
        for what you need to do. I'd look into two things in the server: memory
        and CPU expandability. I know you already plan on 4GB but you may need
        even more in the future. Few things can dramatically improve performance
        more than moving disk access to disk cache. And if there's a 2nd socket
        where you can pop another CPU in, that would leave you extra room if
        your server becomes CPU limited.
        ---------------------------(end of broadcast)---------------------------
        TIP 6: Have you searched our list archives?

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to