public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bruce Momjian <[email protected]>
To: Satoshi Nagayasu <[email protected]>
Cc: [email protected]
Subject: Re: pg_buffercache description
Date: Wed, 3 Jul 2013 14:23:11 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>
On Sat, Nov 24, 2012 at 11:57:51AM +0900, Satoshi Nagayasu wrote:
> 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?
Good suggestion. I ended up referencing the C file that contains the
"forknumber" definitions, rather than recreating the list in the docs.
I applied the attached patch to head and 9.3.
--
Bruce Momjian <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Attachments:
[text/x-diff] buffer.diff (1.2K, 2-buffer.diff)
download | inline diff:
diff --git a/doc/src/sgml/pgbuffercache.sgml b/doc/src/sgml/pgbuffercache.sgml
new file mode 100644
index 1d7d95f..685351f
*** a/doc/src/sgml/pgbuffercache.sgml
--- b/doc/src/sgml/pgbuffercache.sgml
***************
*** 84,90 ****
<entry><structfield>relforknumber</structfield></entry>
<entry><type>smallint</type></entry>
<entry></entry>
! <entry>Fork number within the relation</entry>
</row>
<row>
--- 84,91 ----
<entry><structfield>relforknumber</structfield></entry>
<entry><type>smallint</type></entry>
<entry></entry>
! <entry>Fork number within the relation; see
! <filename>include/storage/relfilenode.h</></entry>
</row>
<row>
***************
*** 98,104 ****
<entry><structfield>usagecount</structfield></entry>
<entry><type>smallint</type></entry>
<entry></entry>
! <entry>Page LRU count</entry>
</row>
</tbody>
--- 99,105 ----
<entry><structfield>usagecount</structfield></entry>
<entry><type>smallint</type></entry>
<entry></entry>
! <entry>Clock-sweep access count</entry>
</row>
</tbody>
view thread (4+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: pg_buffercache description
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox