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 6A4D39DCC0C for ; Mon, 28 Nov 2005 18:07:42 -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 60594-01 for ; Mon, 28 Nov 2005 18:07:42 -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 483D19DCAB7 for ; Mon, 28 Nov 2005 18:07:38 -0400 (AST) Received: from 172.16.1.112 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D2)); Mon, 28 Nov 2005 17:07:26 -0500 X-Server-Uuid: 7829E76E-BB9E-4995-8473-3C0929DF7DD1 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.160]) by D01SMTP02.Mi8.com with Microsoft SMTPSVC(6.0.3790.211); Mon, 28 Nov 2005 17:06:59 -0500 Received: from 67.103.45.218 ([67.103.45.218]) 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, 28 Nov 2005 22:05:14 +0000 User-Agent: Microsoft-Entourage/11.2.1.051004 Date: Mon, 28 Nov 2005 14:05:15 -0800 Subject: Re: Hardware/OS recommendations for large databases ( From: "Luke Lonergan" To: "Mark Kirkwood" , "Merlin Moncure" cc: pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] Hardware/OS recommendations for large databases ( Thread-Index: AcX0ZjyyJ8+6opcfSNKK6fecsFUZHgAAZLNv In-Reply-To: <438B7A8A.4020505@paradise.net.nz> MIME-Version: 1.0 X-OriginalArrivalTime: 28 Nov 2005 22:06:59.0885 (UTC) FILETIME=[0E040DD0:01C5F468] X-WSS-ID: 6F95A1DA4J81252576-94-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.253 required=5 tests=[RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.253 X-Spam-Level: * X-Archive-Number: 200511/540 X-Sequence-Number: 15797 Mark, On 11/28/05 1:45 PM, "Mark Kirkwood" wrote: >>> 8.0 : 32 s >>> 8.1 : 25 s A 22% reduction. select count(1) on 12,900MB = 1617125 pages fully cached: MPP based on 8.0 : 6.06s MPP based on 8.1 : 4.45s A 26% reduction. I'll take it! I am looking to back-port Tom's pre-8.2 changes and test again, maybe tonight. - Luke