Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 6BB796346ED for ; Fri, 13 Mar 2009 22:58:59 -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 51756-03 for ; Fri, 13 Mar 2009 22:58:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og110.obsmtp.com (exprod7og110.obsmtp.com [64.18.2.173]) by mail.postgresql.org (Postfix) with SMTP id 632166341DB for ; Fri, 13 Mar 2009 22:58:56 -0300 (ADT) Received: from source ([209.85.219.165]) by exprod7ob110.postini.com ([64.18.6.12]) with SMTP ID DSNKSbsPXuWOROivfCdkjh9U3wx/Q164TED7@postini.com; Fri, 13 Mar 2009 18:58:55 PDT Received: by ewy9 with SMTP id 9so3838038ewy.31 for ; Fri, 13 Mar 2009 18:58:53 -0700 (PDT) Received: by 10.210.13.9 with SMTP id 9mr1366395ebm.10.1236995933429; Fri, 13 Mar 2009 18:58:53 -0700 (PDT) Received: from oxford.xeocode.com.enterprisedb.com ([87.127.95.198]) by mx.google.com with ESMTPS id 35sm4477772nfu.7.2009.03.13.18.58.52 (version=TLSv1/SSLv3 cipher=RC4-MD5); Fri, 13 Mar 2009 18:58:52 -0700 (PDT) To: Tom Lane Cc: Alan Stange , "Jignesh K. Shah" , 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: <12431.1236965004@sss.pgh.pa.us> (Tom Lane's message of "Fri\, 13 Mar 2009 13\:23\:24 -0400") User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux) X-Draft-From: ("nnimap+imap.gmail.com:PG" 112980) References: <49B922C0.6050700@sun.com> <49BA5537.8060002@sun.com> <87prgl4jbh.fsf@oxford.xeocode.com> <49BA79A4.9030208@rentec.com> <12431.1236965004@sss.pgh.pa.us> From: Gregory Stark Organization: EnterpriseDB Date: Sat, 14 Mar 2009 01:58:50 +0000 Message-ID: <87d4ck50h1.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/180 X-Sequence-Number: 33102 Tom Lane writes: > Alan Stange writes: >> Gregory Stark wrote: >>> AFAIK Opensolaris doesn't implement posix_fadvise() so there's no benefit. > >> It's implemented. I'm guessing it's not what you want to see though: >> http://src.opensolaris.org/source/xref/onnv/onnv-gate/usr/src/lib/libc/port/gen/posix_fadvise.c > > Ugh. So apparently, we actually need to special-case Solaris to not > believe that posix_fadvise works, or we'll waste cycles uselessly > calling a do-nothing function. Thanks, Sun. Do we? Or do we just document that setting effective_cache_size on Solaris won't help? I'm leaning towards the latter because I expect Sun will implement this and there will be people running 8.4 on newer versions of the OS long after it's out. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support!