public inbox for [email protected]  

help / color / mirror / Atom feed

From: Jaime Casanova <[email protected]>
To: pgsql-docs <[email protected]>
Subject: pg_buffercache
Date: Wed, 6 Mar 2013 17:55:21 -0500
Message-ID: <CAJKUy5gH0o-wo-+oLuXoWcPiK5ATRkHMPXEWuUYAYBD4Kptp-Q@mail.gmail.com> (raw)
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>

Hi,

has anyone noted that the structure of the pg_buffercache view in the
docs has relforknumber and relblocknumber swaped.

also, should we add a little description of what values can we find in
relforknumber?

attached is an extremely simple patch to fix both

-- 
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566         Cell: +593 987171157


-- 
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs


Attachments:

  [application/octet-stream] pgbuffercache_docfix.patch (1.2K, 2-pgbuffercache_docfix.patch)
  download | inline diff:
diff --git a/doc/src/sgml/pgbuffercache.sgml b/doc/src/sgml/pgbuffercache.sgml
new file mode 100644
index 1d7d95f..60e45e0
*** a/doc/src/sgml/pgbuffercache.sgml
--- b/doc/src/sgml/pgbuffercache.sgml
***************
*** 74,90 ****
       </row>
  
       <row>
!       <entry><structfield>relblocknumber</structfield></entry>
!       <entry><type>bigint</type></entry>
        <entry></entry>
!       <entry>Page number within the relation</entry>
       </row>
  
       <row>
!       <entry><structfield>relforknumber</structfield></entry>
!       <entry><type>smallint</type></entry>
        <entry></entry>
!       <entry>Fork number within the relation</entry>
       </row>
  
       <row>
--- 74,90 ----
       </row>
  
       <row>
!       <entry><structfield>relforknumber</structfield></entry>
!       <entry><type>smallint</type></entry>
        <entry></entry>
!       <entry>Fork number within the relation. Main table: 0; Free Space Map: 1; Visibility Map: 2; Init fork: 3</entry>
       </row>
  
       <row>
!       <entry><structfield>relblocknumber</structfield></entry>
!       <entry><type>bigint</type></entry>
        <entry></entry>
!       <entry>Page number within the relation</entry>
       </row>
  
       <row>

view thread (2+ 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]
  Subject: Re: pg_buffercache
  In-Reply-To: <CAJKUy5gH0o-wo-+oLuXoWcPiK5ATRkHMPXEWuUYAYBD4Kptp-Q@mail.gmail.com>

* 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