[prev] 53 [next]

Heaps in PostgreSQL

PostgreSQL stores all table data in heap files (by default).

Typically there are also associated index files.

If a file is more useful in some other form:

  • PostgreSQL may make a transformed copy during query execution
  • programmer can set it via   create index...using hash
Heap file implementation:   src/backend/access/heap