public inbox for [email protected]  
help / color / mirror / Atom feed
pg_buffercache
2+ messages / 2 participants
[nested] [flat]

* pg_buffercache
@ 2013-03-06 22:55 Jaime Casanova <[email protected]>
  2013-11-28 03:34 ` Re: pg_buffercache Bruce Momjian <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Jaime Casanova @ 2013-03-06 22:55 UTC (permalink / raw)
  To: pgsql-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>


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: pg_buffercache
  2013-03-06 22:55 pg_buffercache Jaime Casanova <[email protected]>
@ 2013-11-28 03:34 ` Bruce Momjian <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruce Momjian @ 2013-11-28 03:34 UTC (permalink / raw)
  To: Jaime Casanova <[email protected]>; +Cc: pgsql-docs

On Wed, Mar  6, 2013 at 05:55:21PM -0500, Jaime Casanova wrote:
> 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

I have reordered the doc fields to match the view.  The other changes
had already been made.  Sorry for the delay.

-- 
  Bruce Momjian  <[email protected]>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2013-11-28 03:34 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-03-06 22:55 pg_buffercache Jaime Casanova <[email protected]>
2013-11-28 03:34 ` Bruce Momjian <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox