[prev] 50 [next]

PostgreSQL Page Representation (cont)

PostgreSQL has two kinds of pages:
  • heap pages which contain tuples
  • index pages which contain index entries
Both kinds of page have the same page layout.

One important difference:

  • index entries tend be a smaller than tuples
  • can typically fit more index entries per page