sudohulk
Theme

Writing

Everything, newest first: essays, notes still being worked out, and shorter updates. Each stream has its own page and feed; the notes alone, each with how far to trust it, are in Notes.

StreamsAll5Tech4Meta1

Notesall notes3

Tagsall →

SeriesBuilding sudohulk.comPostgreSQL internals, explained simply

SourcePostgreSQL Source Atlas

Pinned

  • Hi, I'm Vignesh. Start here

    meta

    I'm a database engineer at Zoho, working on database internals. Why I write here in public, and how to use the site.

    Building sudohulk.com · part 1 · 3 min · #meta #career

2026

  • How PostgreSQL tells every connection its cache is stale

    explainer

    Each PostgreSQL connection caches the catalog for itself. How a change is announced to all of them at commit through a shared ring, and what happens to a connection that falls behind.

    PostgreSQL internals, explained simply · part 5 · 19 min · #postgresql #databases #performance

  • Full-page writes and torn pages

    note · evergreen

    Why the first change to a page after a checkpoint carries the whole 8 KB page in WAL.

    #postgresql #databases

  • Lazy transaction id assignment

    note · seedling

    A transaction does not get an xid at BEGIN; it gets one the first time it writes.

    #postgresql

  • pd_lsn vs record LSN

    note · budding

    Two LSNs that are easy to mix up, and the rule recovery uses to compare them.

    #postgresql

↑↓ move · ↵ open · esc close