Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 72C6A632342 for ; Fri, 13 Mar 2009 10:57:19 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 79311-03 for ; Fri, 13 Mar 2009 10:57:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og115.obsmtp.com (exprod7og115.obsmtp.com [64.18.2.217]) by mail.postgresql.org (Postfix) with SMTP id 8A28E6322EB for ; Fri, 13 Mar 2009 10:57:11 -0300 (ADT) Received: from source ([209.85.219.170]) by exprod7ob115.postini.com ([64.18.6.12]) with SMTP ID DSNKSbpmNdps7ceMzYG9F44KVGk2AsoXVRpK@postini.com; Fri, 13 Mar 2009 06:57:11 PDT Received: by ewy18 with SMTP id 18so2574367ewy.20 for ; Fri, 13 Mar 2009 06:57:08 -0700 (PDT) Received: by 10.216.26.206 with SMTP id c56mr622444wea.45.1236952628720; Fri, 13 Mar 2009 06:57:08 -0700 (PDT) Received: from oxford.xeocode.com.enterprisedb.com ([82.16.16.210]) by mx.google.com with ESMTPS id 34sm3293924nfu.37.2009.03.13.06.57.07 (version=TLSv1/SSLv3 cipher=RC4-MD5); Fri, 13 Mar 2009 06:57:08 -0700 (PDT) To: "Jignesh K. Shah" Cc: Greg Smith , "pgsql-performance\@postgresql.org" Subject: Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 In-Reply-To: <49BA5537.8060002@sun.com> (Jignesh K. Shah's message of "Fri\, 13 Mar 2009 08\:44\:39 -0400") User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux) X-Draft-From: ("nnimap+imap.gmail.com:PG" 112936) References: <49B922C0.6050700@sun.com> <49BA5537.8060002@sun.com> From: Gregory Stark Organization: EnterpriseDB Date: Fri, 13 Mar 2009 13:57:06 +0000 Message-ID: <87prgl4jbh.fsf@oxford.xeocode.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200903/158 X-Sequence-Number: 33080 A minute ago I said: AFAIK Opensolaris doesn't implement posix_fadvise() so there's no benefit. It would be great to hear if you could catch the ear of the right people to get an implementation committed. Depending on how the i/o scheduler system is written it might not even be hard -- the Linux implementation of WILLNEED is all of 20 lines. I noticed after sending it that that's slightly unfair. The 20-line function calls another function (which calls another function) to do the real readahead work. That function (mm/readahead.c:__do_page_cache_readahead()) is 48 lines. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support!