X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A2BC83A5768 for ; Tue, 11 Jan 2005 13:58:45 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 91071-09 for ; Tue, 11 Jan 2005 13:58:32 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.204]) by svr1.postgresql.org (Postfix) with ESMTP id 59D743A551A for ; Tue, 11 Jan 2005 13:58:34 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 67so182325wri for ; Tue, 11 Jan 2005 05:58:35 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=MW6k9a8CYtHYQjMaiCtH52dnP2KvtZd8JQPe4UfcXBR3vv9zN4u7JYxXKzZdZklv0xq3mMR82L2mYr/vARGuv/6xr47dATKuE+nQAIF8ykPdhX/u1ScAToOpHVVebyyALxJP++efV/ulfGonkffYIDLzgGoo75TmHcLcz/ebQXo= Received: by 10.54.8.5 with SMTP id 5mr78200wrh; Tue, 11 Jan 2005 05:58:34 -0800 (PST) Received: by 10.54.11.6 with HTTP; Tue, 11 Jan 2005 05:58:34 -0800 (PST) Message-ID: <37d451f7050111055846c26085@mail.gmail.com> Date: Tue, 11 Jan 2005 07:58:34 -0600 From: Rosser Schwarz Reply-To: Rosser Schwarz To: Merlin Moncure Subject: Re: which dual-CPU hardware/OS is fastest for PostgreSQL? Cc: Miles Keaton , pgsql-performance@postgresql.org In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3412A75A2@Herge.rcsinc.local> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <6EE64EF3AB31D5448D0007DD34EEB3412A75A2@Herge.rcsinc.local> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200501/133 X-Sequence-Number: 9823 while you weren't looking, Merlin Moncure wrote: > 2 way or 4 way Opteron depending on needs (looking on a price for 4-way? > Go here: http://www.swt.com/qo3.html). Try also the Appro 1U 4-way Opteron server, at: http://www.appro.com/product/server_1142h.asp I specced a 4-way 842 (1.6 GHz: little to none of our db work is CPU bound; there's just a lot of it going on at once) with 32G core for within delta of what SWT wants /just/ for the 32G -- the price of the box itself and anything else atop that. Stepping up to a faster CPU should increase the cost directly in line with the retail price for the silicon. We haven't yet ordered the machine (and the quote was from early last month, so their prices will have fluctuated) and consequently, I can't comment on their quality. Their default warranty is three years, "rapid exchange", though, and they offer on-site service for only nominally more, IIRC. Some slightly more than cursory googling hasn't turned up anything overly negative, either. As a 1U, the box has no appreciable storage of its own but we're shopping for a competent, non bank-breaking fibre setup right now, so that's not an issue for our situation. While on the subject, anyone here have anything to say about JMR fibre raid cabinets? (Fibre-to-fibre, not fibre-to-SATA or the like.) /rls -- :wq