Postgres System Columns Explained (ctid, xmin,xmax) @hnasr
Postgres System Columns Explained (ctid, xmin,xmax)  @hnasr
Uploaded February 2023 | Updated November 2026, 2 days ago
In this video I explain the difference between ctid,xmin and xmax columns in postgres with repeatable read and read committed.

0:00 Intro
2:00 ctid tuple id
7:00 xmin (minimum transaction id) with read committed
8:00 xmin with read committed
13:00 xmin with repeatable read
19:00 xmax (maximum transaction id)



Fundamentals of Backend Engineering Design patterns udemy course (link redirects to udemy with coupon)
backend.husseinnasser.com

Fundamentals of Networking for Effective Backends udemy course (link redirects to udemy with coupon)
network.husseinnasser.com

Fundamentals of Database Engineering udemy course (link redirects to udemy with coupon)
database.husseinnasser.com

Follow me on Medium
medium.com/@hnasr/membership


Introduction to NGINX (link redirects to udemy with coupon)
nginx.husseinnasser.com

Python on the Backend (link redirects to udemy with coupon)
python.husseinnasser.com

Become a Member on YouTube
youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join

Buy me a coffee if you liked this
buymeacoffee.com/hnasr

Arabic Software Engineering Channel
youtube.com/channel/UChWZsjdoRvZ0T9QWZOD6UpA

🔥 Members Only Content
youtube.com/playlist?list=UUMO_ML5xP23TOWKUcc-oAE_Eg



🏭 Backend Engineering Videos in Order
backend.husseinnasser.com

💾 Database Engineering Videos
youtube.com/playlist?list=PLQnljOFTspQXjD0HOzN7P2tgzu7scWpl2

🎙️Listen to the Backend Engineering Podcast
husseinnasser.com/podcast

Gears and tools used on the Channel (affiliates)

🖼️ Slides and Thumbnail Design
Canva
partner.canva.com/c/2766475/647168/10068


Stay Awesome,
Hussein
Postgres System Columns Explained (ctid, xmin,xmax)Short polling is too chatty on the backendHow CPU Efficient is your App?Techs Yin & YangWhy It took Postgres years to do asyncBefore you move to HTTP/3 ...Why is synchronous IO slow?Why you need to close socketsNodeJS Architecture - I/OCreate Index DDLHow many kernel system calls do runtimes make?Cant TCP to the backend? This may be it
Hussein Nasser |

Postgres System Columns Explained (ctid, xmin,xmax)

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER