BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//HasGeek//NONSGML Funnel//EN
DESCRIPTION:Hands-on workshop - Rootconf Topical Edition on Databases
X-WR-CALDESC:Hands-on workshop - Rootconf Topical Edition on Databases
NAME:Write path in OLTP workloads (PostgreSQL)
X-WR-CALNAME:Write path in OLTP workloads (PostgreSQL)
REFRESH-INTERVAL;VALUE=DURATION:PT12H
SUMMARY:Write path in OLTP workloads (PostgreSQL)
TIMEZONE-ID:Asia/Kolkata
X-PUBLISHED-TTL:PT12H
X-WR-TIMEZONE:Asia/Kolkata
BEGIN:VEVENT
SUMMARY:Write path in OLTP workloads (PostgreSQL)
DTSTART:20260612T043000Z
DTEND:20260612T070000Z
DTSTAMP:20260627T212536Z
UID:session/PEyDDwtNiAjaA1iwgAj1AE@hasgeek.com
SEQUENCE:15
CREATED:20260607T020825Z
DESCRIPTION:# 🚨 Venue changed. This workshop will take place at Sahaj S
 oftware.\n\n## 🎯 Target audience\n- Engineers who have worked with Post
 greSQL or other OLTP databases and want to understand what happens under t
 he hood in the write path.\n- Those looking to reason about durability\, p
 erformance\, and isolation trade-offs in production systems\n\n## 📘 Wor
 kshop overview\nThis workshop uses PostgreSQL as a concrete example to exp
 lore the full write path in OLTP workloads — from durability guarantees 
 to concurrency and isolation. \n\nThe workshop pairs internals with observ
 ability — what to measure\, how to debug\, and how to tune — at each s
 tage.\n\n## ✅ Learning outcomes\nBy the end of the workshop\, participan
 ts will be able to understand:\n- How PostgreSQL implements durability usi
 ng WAL\, fsync\, and group commit\n- How the background writer and checkpo
 inter manage write throughput\n- How MVCC provides concurrent readers a co
 nsistent view during writes\n- Operational lessons from running PostgreSQL
  in production for write-heavy workloads\n\n## 🧩 Workshop modules\n**1.
  Write durability guarantees**\nHow PostgreSQL ensures committed transacti
 ons survive crashes. Covers WAL record structure\, the lifecycle of a WAL 
 record from generation to flush\, fsync and group commit\, and parameters 
 like `synchronous_commit`\, `wal_sync_method`\, and `commit_delay`. Storag
 e characteristics (SSD vs HDD\, write cache) and their effect on durabilit
 y expectations.\n\n**2. Write performance**\nHow to sustain high write thr
 oughput without compromising guarantees. Covers how WAL bounds maximum thr
 oughput\, group commit under concurrent workloads\, batching and transacti
 on sizing\, and how the background writer and checkpointer manage dirty bu
 ffers. Observability via `pg_stat_bgwriter`.\n\n**3. Concurrency control**
 \nHow PostgreSQL handles concurrent writes correctly. Covers SQL isolation
  levels\, MVCC — how row versions are created\, visibility rules\, and w
 here WAL fits in — visibility checks using transaction snapshots\, hint 
 bits and clog lookups\, hot row contention\, lock waits via `pg_locks` and
  `pg_stat_activity`\, and preventing lost updates with `SELECT FOR UPDATE`
  and optimistic concurrency control.\n\n**4. Operational lessons from prod
 uction**\nWar stories and concrete scenarios from running PostgreSQL in pr
 oduction for write-heavy OLTP workloads. Covers WAL volume and checkpoint 
 tuning\, bulk ingest and bursty workload patterns\, write contention from 
 centralized counters and hot partitions\, and mitigation strategies includ
 ing schema changes\, sharding\, and query rewrites.\n\n## 🛠 Tooling & p
 rerequisites\n**1. Docker Desktop**\n**2. Visual Studio Code**\n\nThe GitH
 ub repo will package everything as a devcontainer. So clone the repo\, ope
 n in a devcontainer\, and you're all set!\n\n\n## About the instructor\n[*
 *Amit Prabhudesai**](https://www.linkedin.com/in/amitprabhudesai/) is a Te
 ch Lead on the Azure DocumentDB team at Microsoft. He has held both EM and
  TechLead roles\, though he enjoys most leading through influence. In his 
 last stint before joining The MotherShip\, Amit led InMobi China engineeri
 ng.  \n## How to attend\nThis workshop is open for **[Rootconf members](ht
 tps://hasgeek.com/rootconf#memberships)** and for **[Rootconf Data Edition
  ticket buyers](https://hasgeek.com/rootconf/topical-edition-on-databases#
 tickets)**\n\n**This workshop is open to 30 participants (in-person) & hyb
 rid access for remote attendees. Seats for in-person participants will be 
 available on first-come-first-served basis.** 🎟️    \n\n## Contact in
 formation ☎️\nFor inquiries about the workshop\, contact [+91-76763320
 20](tel:+917676332020) or write to [info@hasgeek.com](mailto:info@hasgeek.
 com).
LAST-MODIFIED:20260611T162056Z
LOCATION:Bangalore - https://hasgeek.com/rootconf/oltp-workloads-postgresq
 l-workshop/
ORGANIZER;CN=Rootconf:MAILTO:no-reply@hasgeek.com
URL:https://hasgeek.com/rootconf/oltp-workloads-postgresql-workshop/
BEGIN:VALARM
ACTION:display
DESCRIPTION:Write path in OLTP workloads (PostgreSQL) in 5 minutes
TRIGGER:-PT5M
END:VALARM
END:VEVENT
END:VCALENDAR