Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id B269B9FB4DC for ; Wed, 20 Jun 2007 09:55:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 57562-03 for ; Wed, 20 Jun 2007 09:55:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mx00.pub.collaborativefusion.com (mx00.pub.collaborativefusion.com [206.210.89.199]) by postgresql.org (Postfix) with ESMTP id 2D8239FB4BE for ; Wed, 20 Jun 2007 09:55:48 -0300 (ADT) Received: from vanquish.pgh.priv.collaborativefusion.com (vanquish.pgh.priv.collaborativefusion.com [192.168.2.61]) (SSL: TLSv1/SSLv3,256bits,AES256-SHA) by wingspan with esmtp; Wed, 20 Jun 2007 08:55:46 -0400 id 00056419.467923D2.0000BBA9 Date: Wed, 20 Jun 2007 08:55:46 -0400 From: Bill Moran To: "Sergey Konoplev" Cc: pgsql-performance@postgresql.org Subject: Re: cached entities Message-Id: <20070620085546.bcbf6377.wmoran@collaborativefusion.com> In-Reply-To: References: Organization: Collaborative Fusion X-Mailer: Sylpheed 2.3.1 (GTK+ 2.10.11; i386-portbld-freebsd6.1) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/411 X-Sequence-Number: 25444 In response to "Sergey Konoplev" : > Hi > > I'd like to know how to get information about which PG entities are in > kernel cache, if possible. That's going to be specific to the OS you're running. Unless you're talking about PG's shared_buffers -- if that's the case, have a look at the pg_buffercache contrib module. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ wmoran@collaborativefusion.com Phone: 412-422-3463x4023