Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C5CC69FA22A for ; Fri, 2 Feb 2007 15:27:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 95284-01 for ; Fri, 2 Feb 2007 15:27:03 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from genomemail.chop.edu (genomemail.chop.edu [159.14.214.193]) by postgresql.org (Postfix) with ESMTP id 0AA609FA4AD for ; Fri, 2 Feb 2007 15:27:01 -0400 (AST) Received: from [159.14.214.61] (ibmt42laptop.infosys.chop.edu [159.14.214.61]) BY genomemail.chop.edu ([159.14.214.193]) WITH ESMTP (4D WebSTAR V Mail (5.3.4)); Fri, 02 Feb 2007 14:28:05 -0500 Message-ID: <45C39081.20901@genome.chop.edu> Date: Fri, 02 Feb 2007 14:26:57 -0500 From: Kevin Murphy User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: OT: Mac OS X disk buffer cache Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/29 X-Sequence-Number: 23083 Is there any way of monitoring and/or controlling disk buffer cache allocation and usage on Mac OS X? I'm thinking of two things: 1) being able to give PG a more accurate estimate of the size of the cache, and 2) being able to more quickly flush the cache for testing the performance of cold queries. It would be fantastic for testing to be able to signal both PG and the operating system to invalidate their caches. -Kevin Murphy