pageinspect bt_page_items doc

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: pageinspect bt_page_items doc
Date: 2023-07-24 00:57:05
Message-ID: CACJufxG9bvBRC9zT_ph-MC9jZEOawyqR=ESs5wCG59j2Jxu2Rg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi.

https://www.postgresql.org/docs/current/pageinspect.html#id-1.11.7.34.6

> This is a B-tree leaf page. All tuples that point to the table happen to be posting list tuples (all of which store a total of 100 6 byte TIDs).
> There is also a “high key” tuple at itemoffset number 1. ctid is used to store encoded information about each tuple in this example, though
> leaf page tuples often store a heap TID directly in the ctid field instead. tids is the list of TIDs stored as a posting list.

(all of which store a total of 100 6 byte TIDs)
I think the meaning is something like:
(all of which store a total of 100 TIDs, each TID is 6 byte long.)

What's the meaning of (16, 8292)? After looking around. I'm still confused.
Would it be better to add an explanation about (16, 8292) to the docs?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Julien Rouhaud 2023-07-24 01:46:30 Re: pageinspect bt_page_items doc
Previous Message Ron 2023-07-23 20:05:30 Re: Effects of dropping a large table