Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tc5wQ-00048h-0O for pgsql-docs@postgresql.org; Sat, 24 Nov 2012 02:58:02 +0000 Received: from mail-pa0-f46.google.com ([209.85.220.46]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tc5wL-0003Ju-G7 for pgsql-docs@postgresql.org; Sat, 24 Nov 2012 02:58:00 +0000 Received: by mail-pa0-f46.google.com with SMTP id bh2so3854765pad.19 for ; Fri, 23 Nov 2012 18:57:54 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:subject :content-type:content-transfer-encoding:x-gm-message-state; bh=/WCt0DaE75xQGpv51vU50j3ooouHpNAJxUBTOB4N/6E=; b=iG5r4fNnf5evn0nvJb52yaf4lhuzkOaJ0PF3ZaPndoLdTMvlgKhcNETdmpyqo7BOb2 O5uzN0dOQ+Lk14LIFLdOIuQG78mD4MpQqAREgfBrE7OuL0bERQz76tXSxh+ba2BtR7Wx Fp6T3JWkphv/gGmiQg6PtoHsHWRgU4OKneyuKrger2RgUq4kXEx5RMWzuRAyjIABzixd 8AWFGSWUihBmkb4qHeKINKZb33KMKTC/VXPCHlP3naCOdHys+PB5pXc5yYuaYQnMidxC JizdgQY09zBR31FXJn7H+YSUr42k+lmTjImnaS3+GXhL1MV2wAwRUmEL8/wAWpX0MA3b lIDA== Received: by 10.68.235.208 with SMTP id uo16mr18770564pbc.65.1353725874533; Fri, 23 Nov 2012 18:57:54 -0800 (PST) Received: from [106.189.127.140] (e0109-106-189-127-140.uqwimax.jp. [106.189.127.140]) by mx.google.com with ESMTPS id gq10sm4720542pbc.54.2012.11.23.18.57.52 (version=SSLv3 cipher=OTHER); Fri, 23 Nov 2012 18:57:53 -0800 (PST) Message-ID: <50B037AF.4040900@uptime.jp> Date: Sat, 24 Nov 2012 11:57:51 +0900 From: Satoshi Nagayasu User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/17.0 Thunderbird/17.0 MIME-Version: 1.0 To: pgsql-docs@postgresql.org Subject: pg_buffercache description Content-Type: text/plain; charset=ISO-2022-JP Content-Transfer-Encoding: 7bit X-Gm-Message-State: ALoCoQkn7Y0wmfTZN1kGwjoEfLilW5rfsz3MZlGMc1GHmmHnWCv7Kjy1PXRSlODn/jJzeRBLIMLJ X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201211/15 X-Sequence-Number: 7507 Hi, I found that the manual page for pg_buffercache module explains "usagecount" as "Page LRU count". http://www.postgresql.org/docs/devel/static/pgbuffercache.html However, AFAIK, "usagecount" is not a LRU count nowadays, because LRU is no longer used for the buffer management algorithm. I think it should be described as "Clock-sweep count" or something like that. And I'd like to add some additional explanation for the "forknumber" as below: "0 for heap file, 1 for FreeSpaceMap, and 2 for VisibilityMap". Any comments? Regards, -- Satoshi Nagayasu Uptime Technologies, LLC. http://www.uptime.jp