Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 269419FB7AB for ; Tue, 3 Apr 2007 13:53:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 09538-04-2 for ; Tue, 3 Apr 2007 13:53:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from exprod6og53.obsmtp.com (exprod6og53.obsmtp.com [64.18.1.187]) by postgresql.org (Postfix) with SMTP id B54909FB7F9 for ; Tue, 3 Apr 2007 13:53:20 -0300 (ADT) Received: from source ([63.240.6.44]) (using TLSv1) by exprod6ob53.postini.com ([64.18.5.12]) with SMTP; Tue, 03 Apr 2007 09:53:16 PDT Received: from 172.16.1.25 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D4)); Tue, 03 Apr 2007 12:17:52 -0400 X-Server-Uuid: C8FB4D43-1108-484A-A898-3CBCC7906230 Received: from MI8NYCMAIL08.Mi8.com ([172.16.1.165]) by D01HOST03.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Tue, 3 Apr 2007 12:17:49 -0400 Received: from 24.23.197.133 ([24.23.197.133]) by MI8NYCMAIL08.Mi8.com ( [172.16.1.190]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.118]) with Microsoft Exchange Server HTTP-DAV ; Tue, 3 Apr 2007 16:17:49 +0000 User-Agent: Microsoft-Entourage/11.3.3.061214 Date: Tue, 03 Apr 2007 09:17:47 -0700 Subject: Re: Cache hit ratio From: "Luke Lonergan" To: "Jean Arnaud" , "PostgreSQL Performance" Message-ID: Thread-Topic: [PERFORM] Cache hit ratio Thread-Index: Acd2C53y3KiTQeH+EdugGQAX8s8Cag== In-Reply-To: <461260C4.8050508@inrialpes.fr> MIME-Version: 1.0 X-OriginalArrivalTime: 03 Apr 2007 16:17:49.0910 (UTC) FILETIME=[9FAECF60:01C7760B] X-WSS-ID: 6A0CA1BA3H42811572-01-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/21 X-Sequence-Number: 23898 Set log_executor_stats=true; Then look in the log after running statements (or tail -f logfile). - Luke On 4/3/07 7:12 AM, "Jean Arnaud" wrote: > Hi > > Is there a way to get the cache hit ratio in PostGreSQL ? > > Cheers