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 E7F4B9DCA59 for ; Mon, 30 Jan 2006 03:25:32 -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 18594-04-3 for ; Mon, 30 Jan 2006 03:25:32 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.mi8.com (d01gw02.mi8.com [63.240.6.46]) by postgresql.org (Postfix) with ESMTP id 02D3D9DCA32 for ; Mon, 30 Jan 2006 03:25:29 -0400 (AST) Received: from 172.16.1.112 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D2)); Mon, 30 Jan 2006 02:25:22 -0500 X-Server-Uuid: 7829E76E-BB9E-4995-8473-3C0929DF7DD1 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.175]) by D01SMTP02.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Mon, 30 Jan 2006 02:25:22 -0500 Received: from 69.181.100.71 ([69.181.100.71]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.104]) with Microsoft Exchange Server HTTP-DAV ; Mon, 30 Jan 2006 07:25:22 +0000 User-Agent: Microsoft-Entourage/11.2.1.051004 Date: Sun, 29 Jan 2006 23:25:22 -0800 Subject: Re: Huge Data sets, simple queries From: "Luke Lonergan" To: "Charles Sprickman" cc: "hubert depesz lubaczewski" , pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] Huge Data sets, simple queries Thread-Index: AcYlXvYzEFUVJEA+TBKMsmNFpJsgdAAD14+A In-Reply-To: MIME-Version: 1.0 X-OriginalArrivalTime: 30 Jan 2006 07:25:22.0773 (UTC) FILETIME=[54E79050:01C6256E] X-WSS-ID: 6FC360E82XS295913-01-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.348 required=5 tests=[AWL=0.095, RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.348 X-Spam-Level: * X-Archive-Number: 200601/474 X-Sequence-Number: 16952 Charles, On 1/29/06 9:35 PM, "Charles Sprickman" wrote: > What are you folks using to measure your arrays? Bonnie++ measures random I/Os, numbers we find are typically in the 500/s range, the best I've seen is 1500/s on a large Fibre Channel RAID0 (at http://www.wlug.org.nz/HarddiskBenchmarks). - Luke