X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 13154DBA75 for ; Wed, 16 Nov 2005 14:52:07 -0400 (AST) 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 48805-01-2 for ; Wed, 16 Nov 2005 18:52:06 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from cassarossa.samfundet.no (cassarossa.samfundet.no [129.241.93.19]) by svr1.postgresql.org (Postfix) with ESMTP id 1AD6EDBA71 for ; Wed, 16 Nov 2005 14:52:03 -0400 (AST) Received: from trofast.ipv6.sesse.net ([2001:700:300:dc03:20e:cff:fe36:a766] helo=trofast.sesse.net) by cassarossa.samfundet.no with esmtp (Exim 4.50) id 1EcSO0-0000tl-UB for pgsql-performance@postgresql.org; Wed, 16 Nov 2005 19:52:02 +0100 Received: from sesse by trofast.sesse.net with local (Exim 3.36 #1 (Debian)) id 1EcSNe-0005xF-00 for ; Wed, 16 Nov 2005 19:51:38 +0100 Date: Wed, 16 Nov 2005 19:51:38 +0100 From: "Steinar H. Gunderson" To: pgsql-performance@postgresql.org Subject: Re: Hardware/OS recommendations for large databases ( Message-ID: <20051116185138.GA22831@uio.no> Mail-Followup-To: pgsql-performance@postgresql.org References: <3E37B936B592014B978C4415F90D662D01995F7B@MI8NYCMAIL06.Mi8.com> <33c6269f0511152115v1a34ab81j30f1f5df5a6c6956@mail.gmail.com> <437B3B18.1040509@commandprompt.com> <437B4773.1040404@boreham.org> <1132160785.3582.60.camel@state.g2switchworks.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <1132160785.3582.60.camel@state.g2switchworks.com> X-Operating-System: Linux 2.6.14 on a i686 X-Message-Flag: Outlook? --> http://www.mozilla.org/products/thunderbird/ User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/291 X-Sequence-Number: 15548 On Wed, Nov 16, 2005 at 11:06:25AM -0600, Scott Marlowe wrote: > There was a big commercial EMC style array in the hosting center at the > same place that had something like a 16 wide by 16 tall array of IDE > drives for storing pdf / tiff stuff on it, and we had at least one > failure a month in it. Of course, that's 256 drives, so you're gonna > have failures, and it was configured with a spare on every other row or > some such. We just had a big box of hard drives and it was smart enough > to rebuild automagically when you put a new one in, so the maintenance > wasn't really that bad. The performance was quite impressive too. If you have a cool SAN, it alerts you and removes all data off a disk _before_ it starts giving hard failures :-) /* Steinar */ -- Homepage: http://www.sesse.net/