X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id C12539FB2DA for ; Wed, 20 Sep 2006 21:24:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 70323-04 for ; Thu, 21 Sep 2006 00:24:09 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.Mi8.com (d01gw01.mi8.com [63.240.6.47]) by postgresql.org (Postfix) with ESMTP id 917D89FB22A for ; Wed, 20 Sep 2006 21:24:09 -0300 (ADT) Received: from 172.16.1.25 by mail.Mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D1)); Wed, 20 Sep 2006 20:24:01 -0400 X-Server-Uuid: 241911D6-425B-44B9-A073-E3FE0F8FC774 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.175]) by D01HOST03.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 20 Sep 2006 20:23:33 -0400 Received: from 63.80.24.130 ([63.80.24.130]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.118]) with Microsoft Exchange Server HTTP-DAV ; Thu, 21 Sep 2006 00:23:32 +0000 User-Agent: Microsoft-Entourage/11.2.5.060620 Date: Wed, 20 Sep 2006 17:23:31 -0700 Subject: Re: Large tables (was: RAID 0 not as fast as From: "Luke Lonergan" To: "Markus Schaber" , pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] Large tables (was: RAID 0 not as fast as Thread-Index: AcbdFCqTaQr6FEkHEduvjgAWy4o9DA== In-Reply-To: <4511821E.2030902@logix-tt.com> MIME-Version: 1.0 X-OriginalArrivalTime: 21 Sep 2006 00:23:33.0410 (UTC) FILETIME=[2C02C020:01C6DD14] X-WSS-ID: 690F041539G1031425-09-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200609/275 X-Sequence-Number: 20961 Markus, On 9/20/06 11:02 AM, "Markus Schaber" wrote: > I thought that posix_fadvise() with POSIX_FADV_WILLNEED was exactly > meant for this purpose? This is a good idea - I wasn't aware that this was possible. We'll do some testing and see if it works as advertised on Linux and Solaris. - Luke