Did you mean to say the trigger-based clustering solution is loading the dual CPUs 
60-70% right now?
Performance will not be linear with more processors, but it does help with more 
processes. We haven't benchmarked it, but we haven't had any problems also so far in 
terms of performance.
Price would vary with your relation/yearly purchase, etc, but a 6650 with 2.0GHz/1MB 
cache/8GB Memory, RAID card, drives, etc, should definitely cost you less than 20K USD.

        -----Original Message----- 
        From: Bjoern Metzdorf [mailto:[EMAIL PROTECTED] 
        Sent: Tue 5/11/2004 4:28 PM 
        To: Anjan Dave 
        Cc: [EMAIL PROTECTED]; Pgsql-Admin (E-mail) 
        Subject: Re: [PERFORM] Quad processor options

        Anjan Dave wrote:
        > We use XEON Quads (PowerEdge 6650s) and they work nice,
         > provided you configure the postgres properly.
         > Dell is the cheapest quad you can buy i think.
         > You shouldn't be paying 30K unless you are getting high CPU-cache
         > on each processor and tons of memory.
        good to hear, I tried to online configure a quad xeon here at dell
        germany, but the 6550 is not available for online configuration. at dell
        usa it works. I will give them a call tomorrow.
        > I am actually curious, have you researched/attempted any
         > postgresql clustering solutions?
         > I agree, you can't just keep buying bigger machines.
        There are many asynchronous, trigger based solutions out there (eRserver
        etc..), but what we need is basically a master <-> master setup, which
        seems not to be available soon for postgresql.
        Our current dual Xeon runs at 60-70% average cpu load, which is really
        much. I cannot afford any trigger overhead here. This machine is
        responsible for over 30M page impressions per month, 50 page impressums
        per second at peak times. The autovacuum daemon is a god sent gift :)
        I'm curious how the recently announced mysql cluster will perform,
        although it is not an option for us. postgresql has far superior
        > They have 5 internal drives (4 in RAID 10, 1 spare) on U320,
         > 128MB cache on the PERC controller, 8GB RAM.
        Could you tell me what you paid approximately for this setup?
        How does it perform? It certainly won't be twice as fast a as dual xeon,
        but I remember benchmarking a quad P3 xeon some time ago, and it was
        disappointingly slow...

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


Reply via email to