@tyranny
Rohan Tiwari
@tyranny
Beyond Code
NepalJoined February 2026
About
Nothing here yet.
Available for
Nothing here yet.
Rohan Tiwari's blogs
Recently published
PostgreSQL TOAST Storage Models
Feb 19 · 4 min read · The main problem TOAST solves is fundamental : postgres pages are of 8kb, and tuple must fit within that page. so what happens if you try to insert 1MB of text field ? Without toast you would get an error: "Row too big". With toast PostgreSQL handles...
Join discussion
Tuple Layout
Feb 18 · 5 min read · When you insert a new row into a table, postgreSQL creates a tuple, a contiguous chunk of memory bytes that contains both system metadata and your actual data. A tuple starts with a 23 byte header. Every single tuple in every table has this same head...
Join discussion
PostgreSQL Page Structure - (Slotted Pages)
Feb 18 · 6 min read · From the previous blog we knew that tables are made up of 8KB pages, lets crack open a page and see what's really inside it. This is where the things get interesting because jargons like MVCC, tuple storage, visiblity rules, freespace is dependent on...
Join discussion
Postgres OID VS Relfilenode
Feb 18 · 2 min read · When you create a table, PostgreSQL assigns it an OID (Object Identifier). This is just a logical identifier for the table. it is stored in the system catalog pg_class and remains constant for the lifetime of the table. But under the hood in physical...
Join discussion