Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id E643C9FB1DD; Tue, 24 Apr 2007 07:03:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 12989-01; Tue, 24 Apr 2007 07:03:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mailhost.ics.forth.gr (mailhost.ics.forth.gr [139.91.157.55]) by postgresql.org (Postfix) with ESMTP id 31E929FA601; Tue, 24 Apr 2007 07:03:24 -0300 (ADT) Received: from mailhost.ics.forth.gr (mailhost.ics.forth.gr [139.91.157.55] (may be forged)) by mailhost.ics.forth.gr (8.13.8/ICS-FORTH/V10-Server-2.0.0) with ESMTP id l3OA3MJR018186; Tue, 24 Apr 2007 13:03:22 +0300 Received: from sappho.ics.forth.gr (unknown [127.0.0.1]) by mailhost.ics.forth.gr (Symantec Mail Security) with ESMTP id D556F16C061; Tue, 24 Apr 2007 13:03:22 +0300 (EEST) X-AuditID: 7f000001-a859bbb00000050a-7e-462dd5ea3a01 Received: from SHADOWFAX (unknown [139.91.183.33]) by mailhost.ics.forth.gr (Symantec Mail Security) with ESMTP id 7E7EE8E40FC; Tue, 24 Apr 2007 13:03:22 +0300 (EEST) From: "Sorin N. Ciolofan" To: Cc: Subject: pg_buffercache view Date: Tue, 24 Apr 2007 13:04:16 +0300 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: <20070418095419.169bc6cc.wmoran@potentialtech.com> Thread-Index: AceBwWI6wDaIQT2gT/GKfDlj8KJUKQElSEuw X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 Message-Id: <20070424100322.7E7EE8E40FC@mailhost.ics.forth.gr> X-Brightmail-Tracker: AAAAAA== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/216 X-Sequence-Number: 25280 Dear all, About the pg_buffercache view: I couldn't find the description for this view in the manual at http://www.postgresql.org/docs/8.2/interactive/catalogs.html However I found the readme file provided in the /contrib./pg_buffercache of the source code for version 8.2.3 Here it's written the following description: Column | references | Description ----------------+----------------------+------------------------------------ bufferid | | Id, 1..shared_buffers. relfilenode | pg_class.relfilenode | Refilenode of the relation. reltablespace | pg_tablespace.oid | Tablespace oid of the relation. reldatabase | pg_database.oid | Database for the relation. relblocknumber | | Offset of the page in the relation. isdirty | | Is the page dirty? I've 2 questions: 1) I was not able to find the field "oid" from pg_database view. Could you please tell me what is the actual name of the column for which reldatabase is reffering to? 2) In readme file is also written: "Unused buffers are shown with all fields null except buffered". A "used" buffer means that is used 100% or could it be filled only partially? Is there any way to know at a certain moment with precision how much shared memory expressed in Mb is used? With best regards, Sorin