---
title: "Discussion on \"Understanding Heap File Storage\" | Hashnode"
description: "Discussion on \"Understanding Heap File Storage\". When you execute INSERT INTO users VALUES (1, 'Alice') in PostgreSQL, what actually happens on disk? Where does that data go? How is it organized? Why does a simple SELECTsometimes cause disk writes? These aren't just academic questions—they're the f..."
url: "https://hashnode.com/posts/understanding-heap-file-storage/6995aa1bff9340b3ec1a1ae4"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Understanding Heap File Storage](https://rabindranath-tiwari.com.np/understanding-heap-file-storage?utm_source=hashnode&utm_medium=feed)

When you execute INSERT INTO users VALUES (1, 'Alice') in PostgreSQL, what actually happens on disk? Where does that data go? How is it organized? Why does a simple SELECTsometimes cause disk writes? These aren't just academic questions—they're the f...

Feb 18 · 3 min read · rabindranath-tiwari.com.np  
Read the article

-   [#postgres-optimization](https://hashnode.com/tag/postgres-optimization)
-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#heap](https://hashnode.com/tag/heap)
-   [#postgresql-performance](https://hashnode.com/tag/postgresql-performance)

## Written by

[Rohan Tiwari](https://hashnode.com/@tyranny)

@tyranny · Nepal

  
[View profile](https://hashnode.com/@tyranny)

Beyond Code

## Responses

Markdown supported · ⌘↵ to post

No responses yet.