Articles about postgresql

  • How PostgreSQL stores rows: the heap

    Where PostgreSQL keeps table rows, why an update writes a new row, how deletes leave rows behind for VACUUM, and how every index points back into the heap.