Khan, Mahmood Ahram wrote:
> But for some of the functions like btree index metapage,single btree
> pages,bt page items are not clear to me.

Those functions display the contents of b-tree pages. They're really
meant for debugging purposes. You'll need to understand the internal
structure of a b-tree index to make sense of the output. The b-tree
internals are explained in the source tree, in
src/backend/access/nbtree/README, and the source files in the same

In fact, in 8.3, those functions have been moved to a new, separate
contrib module called pageinspect, along with similar functions for
debugging heap contents. Hopefully that makes the distinction between
functions useful for DBAs and functions useful for developers more clear.

  Heikki Linnakangas

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not

Reply via email to