[prev] 51 [next]

Exercise 6: PostgreSQL Pages

Draw diagrams of a PostgreSQL heap page
  • when it is initially empty
  • after three tuples have been inserted
        with lengths of 60, 80, and 70 bytes
  • after the 80 byte tuple is deleted (but before vacuuming)
  • after a new 50 byte tuple is added
Show the values in the tuple header.

Assume that there is no special space in the page.