Jatin Jain Saraf

I make PostgreSQL work at production scale. Architect of SupraScan (10 TB cut to 2.7 TB). Daily lessons on Postgres, Redis, Node and system design.

Ahmedabad Joined on Jun 11, 2026 https://jatinjainsaraf.com/

Education

Truba Institute of Engineering and Information Technology

Pronouns

he/him

Work

Senior Software Engineer

Jatin Jain Saraf

Oct 9

Turning Your Blockchain Indexer Into a Paid API Without Slowing Down Your Explorer

#blockchain #systemdesign #apidesign #postgres

15 min read

Want to connect with Jatin Jain Saraf?

Create an account to connect with Jatin Jain Saraf. You can also sign in below to proceed if you already have an account.

Create Account

Already have an account? Sign in

Jatin Jain Saraf

Oct 9

Your Postgres Indexes Can Break Without a Single Line of Code Changing

#postgres #postgresinternals #databaseinternals #indexing

13 min read

Jatin Jain Saraf

Oct 9

Your UUID Primary Keys Are Quietly Taxing Every Insert

#postgres #database #performance #indexing

9 min read

Jatin Jain Saraf

Oct 9

The TOAST Tax: How Unbounded JSONB Arrays Cost My Blockchain Indexer 5TB

#postgres #database #performance #jsonb

13 min read

Jatin Jain Saraf

Oct 2

Every Postgres Write Triggers Five Background Processes. Here's What Each One Actually Does.

#postgres #database #wal #vacuum

6 min read

Jatin Jain Saraf

Oct 2

Your ORM Isn't Lying to You. It's Just Not Telling You Everything.

#orm #postgres #database #backenddevelopment

10 min read

Jatin Jain Saraf

Oct 9

A Reliability-Hardening Sprint: Isolation, Guardrails, and a Query Plan That Went From 45 Million to 206

#casestudy #reliability #graphql

5 min read

Jatin Jain Saraf

Oct 9

A Type Migration Across Three Services: VARCHAR to BIGINT at Scale

#casestudy #postgres #schemamigration

3 min read

Jatin Jain Saraf

Oct 9

Built for a Multi-VM Future: The RPC v4 Readiness Work

#casestudy #blockchain #multivm

4 min read

Jatin Jain Saraf

Oct 9

Becoming the Readiness Gate for Another Team's Scale-Up

#casestudy #crossteam #blockchain

3 min read

Jatin Jain Saraf

Oct 9

What It Would Take to Hit 500K TX/Sec, and Why That's the Honest Answer

#casestudy #capacityplanning #systemsdesign

4 min read

Jatin Jain Saraf

Oct 9

From a Redis Relay to a Direct Feed: Rebuilding the Real-Time Pipeline

#casestudy #websockets #redis

5 min read

Jatin Jain Saraf

Oct 9

One Codebase, Five Blockchain Environments

#casestudy #architecture #multienvironment

5 min read

Jatin Jain Saraf

Oct 9

Paying Down Three Years of JSONB Debt

#casestudy #postgres #jsonb

4 min read

Jatin Jain Saraf

Oct 9

Concurrency Design Under High TPS: Moving Wallet Counters Off Database Triggers

#casestudy #postgres #concurrency

6 min read

Jatin Jain Saraf

Oct 9

Exact Analytics in 12KB: Hardening a Wallet-Uniqueness System

#casestudy #hyperloglog #redis

6 min read

Jatin Jain Saraf

Oct 9

Scaling a Blockchain Database From a Single Partition to 4.6 TB

#casestudy #postgres #partitioning

6 min read

Jatin Jain Saraf

Oct 2

The Dual-Write Problem: Why "Update the DB, Then Publish an Event" Is Broken

#systemdesign #distributedsystems #backend #architecture

6 min read

Jatin Jain Saraf

Oct 9

Indexing a Blockchain in Real Time, at Scale

#casestudy #architecture #blockchain

8 min read

Jatin Jain Saraf

Oct 2

Elasticsearch Isn't Dead. You Probably Don't Need It

#postgres #elasticsearch #fulltextsearch #databasearchitecture

5 min read

Jatin Jain Saraf

Oct 2

Why Your Docker Image Is 3GB and Nobody Noticed Until the Deploy Timed Out

#docker #devops #performance

7 min read

Jatin Jain Saraf

Aug 16

Why Postgres and Cassandra Made Opposite Bets on Storage Engines

#postgres #database #architecture #systemdesign

6 min read

Jatin Jain Saraf

Aug 14

The Codebase You Sit In Rubs Off On You

#engineeringculture #softwareengineering #careergrowth #codequality

4 min read

Jatin Jain Saraf

Aug 14

PostgreSQL's Async I/O Engine: Why Your Sequential Scans Just Got 2-3x Faster

#postgres #database #performance #backend

4 min read

Jatin Jain Saraf

Aug 6

Vector Search in Postgres: What pgvector's Indexes Actually Cost You

#postgres #database #ai #backend

8 min read

Jatin Jain Saraf

Aug 3

The Three Layers of Failure Isolation: Timeouts, Circuit Breakers, and Load Shedding

#systemdesign #resilienceengineerin #distributedsystems #backenddevelopment

15 min read

Jatin Jain Saraf

Aug 3

Connection Pooling in the Serverless Era: Five Failure Modes

#postgres #database #serverless #performance

13 min read

Jatin Jain Saraf

Aug 3

PostgreSQL 19 vs. 18: What Actually Changed, Feature by Feature

#postgres #database #backend #softwareengineering

12 min read

Jatin Jain Saraf

Aug 3

Idempotency Keys: How to Make Retries Safe in Distributed Systems

#backend #systemdesign #distributedsystems #architecture

7 min read

Jatin Jain Saraf

Aug 3

How the LRU Cache Actually Works and Why Redis, Browsers, and Postgres All Approximate It

#dsa #systemdesign #caching #redis

4 min read

Jatin Jain Saraf

Aug 3

Why a Single ALTER TABLE Can Take Down Your Whole Database

#postgres #database #backend #sql

5 min read

Jatin Jain Saraf

Aug 3

What the PostgreSQL Server Is Actually Doing

#database #postgres #backend #fundamentals

5 min read

Jatin Jain Saraf

Aug 3

Competition Is Inevitable. Cruelty Is Optional

#career #growth #leadership

1 min read

Jatin Jain Saraf

Jun 26

Transactions and ACID in Practice: What Every Backend Developer Must Know

1 min read

Jatin Jain Saraf

Aug 3

When Judgment Becomes the Bottleneck

#engineeringleadershi #techlead #leadership #softwareengineering

2 min read

Jatin Jain Saraf

Jun 11

Engineering Courses By JJS

#backend #learning #node #postgres

1 min read

Jatin Jain Saraf

Aug 3

Mastering PostgreSQL: 5 Essential Tips for Performance Optimization

#postgres #database #performance #sql

3 min read

Jatin Jain Saraf

Aug 3

Redis HyperLogLog: Counting Millions of Unique Users with Just 12KB of Memory

#redis #hyperloglog #cardinality #probabilisticdatastr

2 min read

Jatin Jain Saraf

Aug 3

A Redis Command That Quietly Solves One of the Hardest Problems in High-Concurrency Systems

#engineering

2 min read

Jatin Jain Saraf

Aug 3

Professionalism Isn't Rigidity — It's Responsibility

#insights

1 min read

Jatin Jain Saraf

Aug 3

The React Server Components Vulnerability That Shocked the Web Ecosystem

#engineering

2 min read

Jatin Jain Saraf

Aug 3

The Responsibility Behind Honest Feedback

#insights #leadership

1 min read

Jatin Jain Saraf

Aug 3

Microservices Don't Collapse Because They're "Too Complex"

#engineering #systemdesign #design

1 min read

Jatin Jain Saraf

Aug 3

Ownership Mindset: Thinking Beyond Assigned Tasks

#insights #leadership

1 min read

Jatin Jain Saraf

Aug 3

The Impact of Words in Professional & Personal Spaces

#insights

1 min read

Jatin Jain Saraf

Aug 3

Your Blockchain Indexer Is Fine — Until It Isn’t

#web3 #blockchain

9 min read

Jatin Jain Saraf

Aug 3

Database Efficiency 101: Understanding Bloat, Vacuum, and the Power of pg_repack

#database #postgres

3 min read

Jatin Jain Saraf

Aug 3

The Power of LATERAL Joins: Turning SQL into a “ForEach” Loop

#database #sql #postgres

6 min read

Jatin Jain Saraf

Aug 3

PostgreSQL 18: A Paradigm Shift for Modern Data Workloads

#database #sql

5 min read

Jatin Jain Saraf

Aug 3

Cloud‑to‑Cloud Database Migration: A Practical Guide for Large PostgreSQL Systems

#database #postgres #cloudmigration #infrastructure

6 min read

Jatin Jain Saraf

Aug 3

The Hidden Architecture Behind Six Degrees of Separation

#architecture #systemdesign

3 min read

Jatin Jain Saraf

Aug 3

The Complete Developer’s Guide to Indexing Assets on Supra & Aptos (Coins, FAs, NFTs)

#database #web3 #performance

6 min read

Jatin Jain Saraf

Aug 3

The PostgreSQL Elephant in the Room: A Deep Dive Into the Architecture That Powers Giants

#database #sql #architecture #systemdesign

7 min read

Jatin Jain Saraf

Aug 3

From Lag to Leading: A Deep Dive into Fixing a 2-Hour PostgreSQL Replication Lag

#database #sql #postgres #performance

4 min read

Jatin Jain Saraf

Aug 3

Taming PostgreSQL Replication Lag in Real-Time Blockchain Indexers

#database #sql #web3 #blockchain

5 min read

Jatin Jain Saraf

Aug 3

Understanding Source Code vs Bytecode in Move-Based Blockchains

#web3 #blockchain

3 min read

Jatin Jain Saraf

Aug 3

Demystifying API Gateway Patterns: Design Choices, Real-World Use Cases & When to Use What

#api #backend #architecture

4 min read

Jatin Jain Saraf

Aug 3

Handling Large Datasets & High-Traffic Queries: Optimizing Pagination, Sorting & Filtering

#engineering

3 min read

Jatin Jain Saraf

Aug 3

The Ultimate Git Command Guide: Streamline Your Development Workflow

#git #developmenttools

6 min read

Jatin Jain Saraf

Aug 3

Strings in JavaScript: An In-Depth Guide

#javascript #frontend

6 min read