X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id CA35E9DC822 for ; Fri, 24 Feb 2006 10:30:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 28893-07 for ; Fri, 24 Feb 2006 10:30:04 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from candle.pha.pa.us (candle.pha.pa.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id 101399DC816 for ; Fri, 24 Feb 2006 10:29:57 -0400 (AST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id k1OETwD07991; Fri, 24 Feb 2006 09:29:58 -0500 (EST) From: Bruce Momjian Message-Id: <200602241429.k1OETwD07991@candle.pha.pa.us> Subject: Re: Reliability recommendations In-Reply-To: <87r764wjg4.fsf@wolfe.cbbrowne.com> To: Christopher Browne Date: Fri, 24 Feb 2006 09:29:58 -0500 (EST) CC: pgsql-performance@postgresql.org X-Mailer: ELM [version 2.4ME+ PL121 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.378 required=5 tests=[AWL=-0.122, RAZOR2_CHECK=0.5] X-Spam-Score: 0.378 X-Spam-Level: X-Archive-Number: 200602/382 X-Sequence-Number: 17368 Christopher Browne wrote: > After takin a swig o' Arrakan spice grog, jd@commandprompt.com ("Joshua D. Drake") belched out: > > Jeremy Haile wrote: > >> We are a small company looking to put together the most cost effective > >> solution for our production database environment. Currently in > >> production Postgres 8.1 is running on this machine: > >> > >> Dell 2850 > >> 2 x 3.0 Ghz Xeon 800Mhz FSB 2MB Cache > >> 4 GB DDR2 400 Mhz > >> 2 x 73 GB 10K SCSI RAID 1 (for xlog and OS) > >> 4 x 146 GB 10K SCSI RAID 10 (for postgres data) > >> Perc4ei controller > >> > >> The above is a standard Dell box with nothing added or modified beyond > >> the options available directly through Dell. > > > You should probably review the archives for PostgreSQL user > > experience with Dell's before you purchase one. > > Hear, hear! We found Dell servers were big-time underperformers. > > Generic hardware put together with generally the same brand names of > components (e.g. - for SCSI controllers and such) would generally play > much better. > > For the cheapo desktop boxes they obviously have to buy the "cheapest > hardware available this week;" it sure seems as though they engage in > the same sort of thing with the "server class" hardware. > > I don't think anyone has been able to forcibly point out any > completely precise shortcoming; just that they underperform what the > specs suggest they ought to be able to provide. Dell often says part X is included, but part X is not the exact same as part X sold by the original manufacturer. To hit a specific price point, Dell is willing to strip thing out of commodity hardware, and often does so even when performance suffers. For many people, this is unacceptable. -- Bruce Momjian http://candle.pha.pa.us SRA OSS, Inc. http://www.sraoss.com + If your life is a hard drive, Christ can be your backup. +