Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 33EBA2E0045 for ; Tue, 8 Apr 2008 09:00:15 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 40567-02 for ; Tue, 8 Apr 2008 09:00:03 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by developer.postgresql.org (Postfix) with ESMTP id 51F9A2E003E for ; Tue, 8 Apr 2008 09:00:10 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id CDE81470008 for ; Tue, 8 Apr 2008 14:00:07 +0200 (CEST) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id lhVQZoz69rRs for ; Tue, 8 Apr 2008 14:00:07 +0200 (CEST) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id BA92B470007; Tue, 8 Apr 2008 14:00:07 +0200 (CEST) Date: Tue, 8 Apr 2008 14:00:07 +0200 From: Tino Schwarze To: pgsql-admin@postgresql.org Subject: Re: Handling large volumes of data Message-ID: <20080408120007.GC29990@easy2.in-chemnitz.de> References: <20080408094233.GG13409@sun.ac.za> <200804081201.15175@zmi.at> <20080408101336.GJ13409@sun.ac.za> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20080408101336.GJ13409@sun.ac.za> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/73 X-Sequence-Number: 28837 On Tue, Apr 08, 2008 at 12:13:36PM +0200, Johann Spies wrote: > > > This took about a week on a 2xCPU quadcore server with 8Gb RAM. > > > > This is not the most interesting thing here. What disk I/O subsystem do > > you use? At least a hardware RAID controller with RAID 0 or 10 should > > be used, with 10krpm or 15krpm drives. SAS preferred, as on SATA the > > only quick disks are Western Digital Raptor (which aren't too bad, > > btw). > > I have got 8x720G disks in a hardware raid 5 setup. It is a Dell 2950 > server. I thought, the 2950 can only take 6 3.5" disks? Or are these 72GB 2.5" ones? Then there are 15k SAS drives available. > I am using an XFS-filesystem. I am not certain about the > speed of the hard disk, but we bought the fastest we could get. Bye, Tino. -- „Es gibt keinen Weg zum Frieden. Der Frieden ist der Weg.” (Mahatma Gandhi) www.craniosacralzentrum.de www.forteego.de