Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 7512E9F9AC8 for ; Thu, 20 Sep 2007 12:14:14 -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 83767-06 for ; Thu, 20 Sep 2007 12:14:02 -0300 (ADT) X-Greylist: delayed 00:06:00.915755 by SQLgrey-1.7.5 Received: from webmail27.mail.yandex.net (webmail27.mail.yandex.net [213.180.200.104]) by postgresql.org (Postfix) with ESMTP id 0EEA89F9A59 for ; Thu, 20 Sep 2007 12:14:02 -0300 (ADT) Received: from YAMAIL (webmail27) by mail.yandex.ru id S5567674AbXITPHt for ; Thu, 20 Sep 2007 19:07:49 +0400 X-Yandex-Spam: 1 Received: from [81.222.82.206] ([81.222.82.206]) by mail.yandex.ru with HTTP; Thu, 20 Sep 2007 19:07:49 +0400 From: =?KOI8-R?B?59LJx8/Sycog9MnUz9c=?= To: pgsql-admin@postgresql.org Subject: wholly / partially table read into shared buffer MIME-Version: 1.0 Message-Id: <42071190300869@webmail27.yandex.ru> Date: Thu, 20 Sep 2007 19:07:49 +0400 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=BAYES_50=0.001, UNPARSEABLE_RELAY=0.001 X-Spam-Level: X-Archive-Number: 200709/122 X-Sequence-Number: 26883 Hello! I am newbie in Postgres, but previously worked with Oracle. Now I am puzzled with heap_blks_hit/heap_blks_read ratio. I make select from table (whose size is larger than shared_buffer) and saw that it was wholly read from disk after second, third and so on runs. Isn't is wrong that RDBMS tries to cache table data blocks at least PARTIALLY in the case of insufficient cache buffer? WBW&R, Grigory Titov.