| 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: | Whole Thread | Raw Message | 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?
| 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 |