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 A45EB9DC897 for ; Wed, 15 Feb 2006 14:01:35 -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 81557-02 for ; Wed, 15 Feb 2006 14:01:34 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by postgresql.org (Postfix) with ESMTP id 544F19DC835 for ; Wed, 15 Feb 2006 14:01:32 -0400 (AST) Received: from [192.168.1.100] (or-67-76-146-141.sta.sprint-hsd.net [67.76.146.141]) (authenticated bits=0) by hosting.commandprompt.com (8.13.4/8.13.4) with ESMTP id k1FHoCfi017797; Wed, 15 Feb 2006 09:50:14 -0800 Message-ID: <43F36D51.5090502@commandprompt.com> Date: Wed, 15 Feb 2006 10:05:05 -0800 From: "Joshua D. Drake" User-Agent: Thunderbird 1.5 (X11/20051201) MIME-Version: 1.0 To: Jeremy Haile CC: pgsql-performance@postgresql.org Subject: Re: Reliability recommendations References: <20060215090446.2F3AC1B819F@mx1.hub.org> <1140018387.43f34cd36a076@imp2-g19.free.fr> <1140018967.43f34f1761803@imp2-g19.free.fr> <1140020490.9369.254450363@webmail.messagingengine.com> In-Reply-To: <1140020490.9369.254450363@webmail.messagingengine.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (hosting.commandprompt.com [192.168.1.101]); Wed, 15 Feb 2006 09:50:14 -0800 (PST) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.086 required=5 tests=[AWL=0.086] X-Spam-Score: 0.086 X-Spam-Level: X-Archive-Number: 200602/207 X-Sequence-Number: 17193 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. > I sent our scenario to our sales team at Dell and they came back with > all manner of SAN, DAS, and configuration costing as much as $50k. > HAHAHAHAHA.... Don't do that. Dell is making the assumption you won't do your homework. Make sure you cross quote with IBM, Compaq and Penguin Computing... Sincerely, Joshua D. Drake -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: PLphp, PLperl - http://www.commandprompt.com/