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
|