---
title: "Discussion on \"What Actually Happens Inside PostgreSQL When You UPDATE a Row?\n\n\" | Hashnode"
description: "Discussion on \"What Actually Happens Inside PostgreSQL When You UPDATE a Row?\n\n\". What happens when you UPDATE a row in PostgreSQL? Understand pages, CTIDs, indexes, MVCC, tuple versions, HOT updates, and VACUUM."
url: "https://hashnode.com/posts/what-actually-happens-inside-postgresql-when-you-update-a-row/6a8240ebb155766e35ab18e9"
---

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

Discussion

# [What Actually Happens Inside PostgreSQL When You UPDATE a Row?](https://guidetodevelopment.hashnode.dev/what-actually-happens-inside-postgresql-when-you-update-a-row?utm_source=hashnode&utm_medium=feed)

What happens when you UPDATE a row in PostgreSQL? Understand pages, CTIDs, indexes, MVCC, tuple versions, HOT updates, and VACUUM.

Aug 16 · 7 min read · guidetodevelopment.hashnode.dev  
Read the article

-   [#postgres](https://hashnode.com/tag/postgres)
-   [#databases](https://hashnode.com/tag/databases)
-   [#backend](https://hashnode.com/tag/backend)
-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#database](https://hashnode.com/tag/database)
-   [#database-internals](https://hashnode.com/tag/database-internals)

## Written by

[Ujjwal Agarwal](https://hashnode.com/@ujjwalcode)

@ujjwalcode

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

Full Stack Engineer | Backend Engineer | AI Engineer

## Responses

Markdown supported · ⌘↵ to post

No responses yet.