---
title: "#postgres-optimization articles | Hashnode"
description: "Explore 1 articles tagged #postgres-optimization on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/postgres-optimization"
---

Tag

# #postgres-optimization

1 posts · 0 followers

[Rohan Tiwari](https://hashnode.com/@tyranny) · [Feb 18](https://hashnode.com/posts/understanding-heap-file-storage/6995aa1bff9340b3ec1a1ae4)

### [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...

3 min read · [rabindranath-tiwari.com.np](https://rabindranath-tiwari.com.np/understanding-heap-file-storage?utm_source=hashnode&utm_medium=feed)