Re: [PERFORM] Hardware/OS recommendations for large databases (</TIT= LE> </HEAD> <BODY> Mark,= On 11/18/05 3:46 PM, "Mark Kirkwood" <markir@paradise.net.nz&g= t; wrote: <BLOCKQUOTE>If you alter this to involve more complex joins (e.g 4.= way star) and (maybe add a small number of concurrent executors too) - is it still the<BR= > case? </BLOCKQUOTE> I may not have listened to you - are you asking about whether the readahead= works for these cases? I’ll be running some massive TPC-H benchmarks on these machines soon = – we’ll see then. - Luke </BODY> </HTML> --B_3215174759

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 D43C3DBB34 for ; Fri, 18 Nov 2005 20:06:08 -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 11939-01 for ; Sat, 19 Nov 2005 00:06:10 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.mi8.com (d01gw04.mi8.com [63.240.6.44]) by svr1.postgresql.org (Postfix) with ESMTP id 09D9FDBB3A for ; Fri, 18 Nov 2005 20:06:05 -0400 (AST) Received: from 172.16.1.110 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D4)); Fri, 18 Nov 2005 19:06:01 -0500 X-Server-Uuid: C8FB4D43-1108-484A-A898-3CBCC7906230 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.175]) by D01SMTP01.Mi8.com with Microsoft SMTPSVC(6.0.3790.211); Fri, 18 Nov 2005 19:06:01 -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.105]) with Microsoft Exchange Server HTTP-DAV ; Fri, 18 Nov 2005 19:06:01 -0500 User-Agent: Microsoft-Entourage/11.2.1.051004 Date: Fri, 18 Nov 2005 16:05:59 -0800 Subject: Re: Hardware/OS recommendations for large databases ( From: "Luke Lonergan" To: "Mark Kirkwood" cc: "Dave Cramer" , "Greg Stark" , "Joshua Marsh" , pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] Hardware/OS recommendations for large databases ( Thread-Index: AcXsmmQi55EBnDCuTAK/LsJ/SGHiVAAAqD/h In-Reply-To: <437E67EE.4070605@paradise.net.nz> MIME-Version: 1.0 X-OriginalArrivalTime: 19 Nov 2005 00:06:01.0725 (UTC) FILETIME=[06C0DAD0:01C5EC9D] X-WSS-ID: 6F60B3E331S14978187-01-01 Content-Type: multipart/alternative; boundary=B_3215174759_3942834 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.254 required=5 tests=[AWL=-0.000, HTML_MESSAGE=0.001, RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.254 X-Spam-Level: * X-Archive-Number: 200511/386 X-Sequence-Number: 15643 > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3215174759_3942834 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Mark, On 11/18/05 3:46 PM, "Mark Kirkwood" wrote: > If you alter this to involve more complex joins (e.g 4. way star) and > (maybe add a small number of concurrent executors too) - is it still the > case? I may not have listened to you - are you asking about whether the readahead works for these cases? I=B9ll be running some massive TPC-H benchmarks on these machines soon =AD we=B9l= l see then. - Luke --B_3215174759_3942834 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Re: [PERFORM] Hardware/OS recommendations for large databases (</TIT= LE> </HEAD> <BODY> Mark,= On 11/18/05 3:46 PM, "Mark Kirkwood" <markir@paradise.net.nz&g= t; wrote: <BLOCKQUOTE>If you alter this to involve more complex joins (e.g 4.= way star) and (maybe add a small number of concurrent executors too) - is it still the<BR= > case? </BLOCKQUOTE> I may not have listened to you - are you asking about whether the readahead= works for these cases? I’ll be running some massive TPC-H benchmarks on these machines soon = – we’ll see then. - Luke </BODY> </HTML> --B_3215174759_3942834--