corpus.blog
41554 blogs · [ { "id": "01a0ba09-5ee2-71dd-b2d3-715abff2a746", "title": "Every Postgres Write Triggers Five Background Processes. Here's What Each One Actually Does.", "url": "https://insight.jatinjainsaraf.com/postgres-wal-checkpoints-wait-events-vacuum-analyze-explained", "published_at": "2026-09-14T05:05:17+00:00" }, { "id": "01a08787-7c7d-73df-8867-3dd1b7cabe1a", "title": "Your ORM Isn't Lying to You. It's Just Not Telling You Everything.", "url": "https://insight.jatinjainsaraf.com/postgresql-orms-what-they-hide", "published_at": "2026-09-03T13:32:46+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cdf7a4010", "title": "The Dual-Write Problem: Why \"Update the DB, Then Publish an Event\" Is Broken", "url": "https://insight.jatinjainsaraf.com/the-dual-write-problem-outbox-sagas-and-2pc", "published_at": "2026-08-29T03:28:24+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36ce016ab60", "title": "Elasticsearch Isn't Dead. You Probably Don't Need It", "url": "https://insight.jatinjainsaraf.com/elasticsearch-isnt-dead-you-probably-dont-need-it", "published_at": "2026-08-21T01:34:27+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36ce104656a", "title": "Why Your Docker Image Is 3GB and Nobody Noticed Until the Deploy Timed Out", "url": "https://insight.jatinjainsaraf.com/docker-image-bloat-stale-layers", "published_at": "2026-08-19T17:41:42+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36ce110cacc", "title": "Why Postgres and Cassandra Made Opposite Bets on Storage Engines", "url": "https://insight.jatinjainsaraf.com/why-postgres-and-cassandra-made-opposite-bets-on-storage-engines", "published_at": "2026-08-15T09:54:24+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36ce1338a33", "title": "The Codebase You Sit In Rubs Off On You", "url": "https://insight.jatinjainsaraf.com/the-codebase-you-sit-in-rubs-off-on-you", "published_at": "2026-08-11T17:55:26+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36ce1aa0e65", "title": "PostgreSQL's Async I/O Engine: Why Your Sequential Scans Just Got 2-3x Faster", "url": "https://insight.jatinjainsaraf.com/postgresql-async-io-engine-explained", "published_at": "2026-08-08T16:23:05+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36ce2a2e2c4", "title": "Vector Search in Postgres: What pgvector's Indexes Actually Cost You", "url": "https://insight.jatinjainsaraf.com/vector-search-in-postgres-what-pgvector-s-indexes-actually-cost-you", "published_at": "2026-08-05T18:23:39+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36ce2f76c62", "title": "The Three Layers of Failure Isolation: Timeouts, Circuit Breakers, and Load Shedding", "url": "https://insight.jatinjainsaraf.com/the-three-layers-of-failure-isolation-timeouts-circuit-breakers-and-load-shedding", "published_at": "2026-08-03T17:53:46+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36ce3e2bc02", "title": "Connection Pooling in the Serverless Era: Five Failure Modes", "url": "https://insight.jatinjainsaraf.com/connection-pooling-in-the-serverless-era-five-failure-modes", "published_at": "2026-08-02T08:23:44+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36ce494c609", "title": "PostgreSQL 19 vs. 18: What Actually Changed, Feature by Feature", "url": "https://insight.jatinjainsaraf.com/postgresql-19-vs-18-what-actually-changed-feature-by-feature", "published_at": "2026-07-27T15:23:36+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36ce4a3a493", "title": "Idempotency Keys: How to Make Retries Safe in Distributed Systems", "url": "https://insight.jatinjainsaraf.com/idempotency-keys-how-to-make-retries-safe-in-distributed-systems", "published_at": "2026-07-24T20:34:05+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36ce59333d5", "title": "How the LRU Cache Actually Works and Why Redis, Browsers, and Postgres All Approximate It", "url": "https://insight.jatinjainsaraf.com/how-the-lru-cache-actually-works-and-why-redis-browsers-and-postgres-all-approximate-it", "published_at": "2026-07-21T19:19:44+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36ce60eccf9", "title": "Why a Single ALTER TABLE Can Take Down Your Whole Database", "url": "https://insight.jatinjainsaraf.com/why-a-single-alter-table-can-take-down-your-whole-database", "published_at": "2026-07-15T16:05:59+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36ce6b034ae", "title": "What the PostgreSQL Server Is Actually Doing", "url": "https://insight.jatinjainsaraf.com/what-the-postgresql-server-is-actually-doing", "published_at": "2026-07-11T09:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36ce738c04a", "title": "Competition Is Inevitable. Cruelty Is Optional", "url": "https://insight.jatinjainsaraf.com/competition-is-inevitable-cruelty-is-optional", "published_at": "2026-06-30T14:47:34+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36ce77e3156", "title": "Transactions and ACID in Practice: What Every Backend Developer Must Know", "url": "https://insight.jatinjainsaraf.com/transactions-and-acid-in-practice-what-every-backend-developer-must-know", "published_at": "2026-06-26T18:34:06+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36ce7df88d8", "title": "When Judgment Becomes the Bottleneck", "url": "https://insight.jatinjainsaraf.com/when-judgment-becomes-the-bottleneck", "published_at": "2026-06-21T17:29:30+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36ce8ad7051", "title": "Mastering PostgreSQL: 5 Essential Tips for Performance Optimization", "url": "https://insight.jatinjainsaraf.com/mastering-postgresql-5-essential-tips-for-performance-optimization", "published_at": "2026-06-11T16:27:25+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36ce9834f5b", "title": "Redis HyperLogLog: Counting Millions of Unique Users with Just 12KB of Memory", "url": "https://insight.jatinjainsaraf.com/redis-hyperloglog-counting-millions-of-unique-users-with-just-12kb-of-memory", "published_at": "2026-06-06T07:49:29+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cea55e82e", "title": "Microservices Don't Collapse Because They're \"Too Complex\"", "url": "https://insight.jatinjainsaraf.com/microservices-system-design-software-architecture", "published_at": "2026-05-30T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cead49e15", "title": "Professionalism Isn't Rigidity — It's Responsibility", "url": "https://insight.jatinjainsaraf.com/work-culture-professionalism-team-communication", "published_at": "2026-05-30T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36ceb5426f7", "title": "The Responsibility Behind Honest Feedback", "url": "https://insight.jatinjainsaraf.com/leadership-wisdom-workplace-ethics-responsible-leadership", "published_at": "2026-05-30T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36ceba602fb", "title": "The Impact of Words in Professional & Personal Spaces", "url": "https://insight.jatinjainsaraf.com/the-impact-of-words-in-professional-personal", "published_at": "2026-05-30T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cec5a144f", "title": "A Redis Command That Quietly Solves One of the Hardest Problems in High-Concurrency Systems", "url": "https://insight.jatinjainsaraf.com/redis-backend-development", "published_at": "2026-05-30T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cece8dbe3", "title": "The React Server Components Vulnerability That Shocked the Web Ecosystem", "url": "https://insight.jatinjainsaraf.com/react-js-next-js-security", "published_at": "2026-05-30T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36ceda936a0", "title": "Ownership Mindset: Thinking Beyond Assigned Tasks", "url": "https://insight.jatinjainsaraf.com/ownership-mindset-leadership-software-engineering", "published_at": "2026-05-30T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cee61c101", "title": "Your Blockchain Indexer Is Fine — Until It Isn’t", "url": "https://insight.jatinjainsaraf.com/your-blockchain-indexer-is-fine-until-it-isnt", "published_at": "2026-05-05T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cef16642e", "title": "Database Efficiency 101: Understanding Bloat, Vacuum, and the Power of pg_repack", "url": "https://insight.jatinjainsaraf.com/database-efficiency-101-understanding-bloat-vacuum-and-the-power-of-pg_repack", "published_at": "2026-03-13T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cefefaf87", "title": "The Power of LATERAL Joins: Turning SQL into a “ForEach” Loop", "url": "https://insight.jatinjainsaraf.com/the-power-of-lateral-joins-turning-sql-into-a-foreach-loop", "published_at": "2026-02-27T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cf04a772d", "title": "PostgreSQL 18: A Paradigm Shift for Modern Data Workloads", "url": "https://insight.jatinjainsaraf.com/postgresql-18-a-paradigm-shift-for-modern-data-workloads", "published_at": "2026-02-21T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cf1326eca", "title": "Cloud‑to‑Cloud Database Migration: A Practical Guide for Large PostgreSQL Systems", "url": "https://insight.jatinjainsaraf.com/cloudtocloud-database-migration-a-practical-guide-for-large-postgresql-systems", "published_at": "2026-01-11T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cf223a223", "title": "The Hidden Architecture Behind Six Degrees of Separation", "url": "https://insight.jatinjainsaraf.com/the-hidden-architecture-behind-six-degrees-of-separation", "published_at": "2025-12-11T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cf26f1911", "title": "The Complete Developer’s Guide to Indexing Assets on Supra & Aptos (Coins, FAs, NFTs)", "url": "https://insight.jatinjainsaraf.com/the-complete-developers-guide-to-indexing-assets-on-supra-aptos-coins-fas-nfts", "published_at": "2025-11-20T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cf33c6a87", "title": "The PostgreSQL Elephant in the Room: A Deep Dive Into the Architecture That Powers Giants", "url": "https://insight.jatinjainsaraf.com/the-postgresql-elephant-in-the-room-a-deep-dive-into-the-architecture-that-powers-giants", "published_at": "2025-07-27T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cf41c9eeb", "title": "From Lag to Leading: A Deep Dive into Fixing a 2-Hour PostgreSQL Replication Lag", "url": "https://insight.jatinjainsaraf.com/from-lag-to-leading-a-deep-dive-into-fixing-a-2-hour-postgresql-replication-lag", "published_at": "2025-07-23T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cf4aa038d", "title": "Taming PostgreSQL Replication Lag in Real-Time Blockchain Indexers", "url": "https://insight.jatinjainsaraf.com/taming-postgresql-replication-lag-in-real-time-blockchain-indexers", "published_at": "2025-07-10T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cf4d29946", "title": "Understanding Source Code vs Bytecode in Move-Based Blockchains", "url": "https://insight.jatinjainsaraf.com/understanding-source-code-vs-bytecode-in-move-based-blockchains", "published_at": "2025-05-07T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cf57dcb7c", "title": "Demystifying API Gateway Patterns: Design Choices, Real-World Use Cases & When to Use What", "url": "https://insight.jatinjainsaraf.com/demystifying-api-gateway-patterns-design-choices-real-world-use-cases-when-to-use-what", "published_at": "2025-04-09T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cf5bd913b", "title": "Handling Large Datasets & High-Traffic Queries: Optimizing Pagination, Sorting & Filtering", "url": "https://insight.jatinjainsaraf.com/handling-large-datasets-high-traffic-queries-optimizing-pagination-sorting-filtering", "published_at": "2025-02-22T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cf625a913", "title": "The Ultimate Git Command Guide: Streamline Your Development Workflow", "url": "https://insight.jatinjainsaraf.com/the-ultimate-git-command-guide-streamline-your-development-workflow", "published_at": "2024-07-09T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cf6d67ad7", "title": "Strings in JavaScript: An In-Depth Guide", "url": "https://insight.jatinjainsaraf.com/strings-in-javascript-an-in-depth-guide", "published_at": "2024-06-21T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cf7c9520a", "title": "Choosing Between Type and Interface in TypeScript: A Detailed Guide", "url": "https://insight.jatinjainsaraf.com/choosing-between-type-and-interface-in-typescript-a-detailed-guide", "published_at": "2024-06-19T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cf890cad4", "title": "Unveiling the Power of Descriptive Naming Conventions in JavaScript", "url": "https://insight.jatinjainsaraf.com/unveiling-the-power-of-descriptive-naming-conventions-in-javascript", "published_at": "2024-05-29T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cf9403448", "title": "Navigating Your Career: Deciding Which Skills to Develop at Each Stage", "url": "https://insight.jatinjainsaraf.com/navigating-your-career-deciding-which-skills-to-develop-at-each-stage", "published_at": "2024-04-26T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cf9fe4fdc", "title": "What's New in Next.js 14", "url": "https://insight.jatinjainsaraf.com/nextjs-14-release-overview", "published_at": "2024-02-26T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cfa2114b7", "title": "Linux Terminal Basics Commands:", "url": "https://insight.jatinjainsaraf.com/linux-terminal-basics-commands", "published_at": "2023-12-20T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cfa8a6898", "title": "JavaScript ES6 Coding Conventions", "url": "https://insight.jatinjainsaraf.com/javascript-es6-coding-conventions", "published_at": "2023-12-19T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cfb05f0d1", "title": "40 Best Practices for Writing Clean JavaScript, React, and Node.js Code", "url": "https://insight.jatinjainsaraf.com/40-best-practices-for-writing-clean-javascript-react-and-nodejs-code", "published_at": "2023-09-01T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cfbb464bb", "title": "Branching Guidelines and Conventions", "url": "https://insight.jatinjainsaraf.com/branching-guidelines-and-conventions", "published_at": "2023-08-24T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cfc37bc9a", "title": "Sequelize using Postgres dialect", "url": "https://insight.jatinjainsaraf.com/sequelize-using-postgres-dialect", "published_at": "2023-08-07T00:00:00+00:00" }, { "id": "01a08787-7c7e-71af-9610-e36cfcfb8013", "title": "Clustering In NodeJs", "url": "https://insight.jatinjainsaraf.com/clustering-in-nodejs", "published_at": "2023-08-07T00:00:00+00:00" } ] posts Claim your blog
Back to insight.jatinjainsaraf.com
Blog · corpus.blog/blogs/insight.jatinjainsaraf.com/posts

insight.jatinjainsaraf.com

insight.jatinjainsaraf.com

2026

Every Postgres Write Triggers Five Background Processes. Here's What Each One Actually Does.original ↗
14 Sept 2026
Your ORM Isn't Lying to You. It's Just Not Telling You Everything.original ↗
3 Sept 2026
The Dual-Write Problem: Why "Update the DB, Then Publish an Event" Is Brokenoriginal ↗
29 Aug 2026
Elasticsearch Isn't Dead. You Probably Don't Need Itoriginal ↗
21 Aug 2026
Why Your Docker Image Is 3GB and Nobody Noticed Until the Deploy Timed Outoriginal ↗
19 Aug 2026
Why Postgres and Cassandra Made Opposite Bets on Storage Enginesoriginal ↗
15 Aug 2026
The Codebase You Sit In Rubs Off On Youoriginal ↗
11 Aug 2026
PostgreSQL's Async I/O Engine: Why Your Sequential Scans Just Got 2-3x Fasteroriginal ↗
8 Aug 2026
Vector Search in Postgres: What pgvector's Indexes Actually Cost Youoriginal ↗
5 Aug 2026
The Three Layers of Failure Isolation: Timeouts, Circuit Breakers, and Load Sheddingoriginal ↗
3 Aug 2026
Connection Pooling in the Serverless Era: Five Failure Modesoriginal ↗
2 Aug 2026
PostgreSQL 19 vs. 18: What Actually Changed, Feature by Featureoriginal ↗
27 Jul 2026
Idempotency Keys: How to Make Retries Safe in Distributed Systemsoriginal ↗
24 Jul 2026
How the LRU Cache Actually Works and Why Redis, Browsers, and Postgres All Approximate Itoriginal ↗
21 Jul 2026
Why a Single ALTER TABLE Can Take Down Your Whole Databaseoriginal ↗
15 Jul 2026
What the PostgreSQL Server Is Actually Doingoriginal ↗
11 Jul 2026
Competition Is Inevitable. Cruelty Is Optionaloriginal ↗
30 Jun 2026
Transactions and ACID in Practice: What Every Backend Developer Must Knoworiginal ↗
26 Jun 2026
When Judgment Becomes the Bottleneckoriginal ↗
21 Jun 2026
Mastering PostgreSQL: 5 Essential Tips for Performance Optimizationoriginal ↗
11 Jun 2026
Redis HyperLogLog: Counting Millions of Unique Users with Just 12KB of Memoryoriginal ↗
6 Jun 2026
Microservices Don't Collapse Because They're "Too Complex"original ↗
30 May 2026
Professionalism Isn't Rigidity — It's Responsibilityoriginal ↗
30 May 2026
The Responsibility Behind Honest Feedbackoriginal ↗
30 May 2026
The Impact of Words in Professional & Personal Spacesoriginal ↗
30 May 2026
A Redis Command That Quietly Solves One of the Hardest Problems in High-Concurrency Systemsoriginal ↗
30 May 2026
The React Server Components Vulnerability That Shocked the Web Ecosystemoriginal ↗
30 May 2026
Ownership Mindset: Thinking Beyond Assigned Tasksoriginal ↗
30 May 2026
Your Blockchain Indexer Is Fine — Until It Isn’toriginal ↗
5 May 2026
Database Efficiency 101: Understanding Bloat, Vacuum, and the Power of pg_repackoriginal ↗
13 Mar 2026
The Power of LATERAL Joins: Turning SQL into a “ForEach” Looporiginal ↗
27 Feb 2026
PostgreSQL 18: A Paradigm Shift for Modern Data Workloadsoriginal ↗
21 Feb 2026
Cloud‑to‑Cloud Database Migration: A Practical Guide for Large PostgreSQL Systemsoriginal ↗
11 Jan 2026

2025

The Hidden Architecture Behind Six Degrees of Separationoriginal ↗
11 Dec 2025
The Complete Developer’s Guide to Indexing Assets on Supra & Aptos (Coins, FAs, NFTs)original ↗
20 Nov 2025
The PostgreSQL Elephant in the Room: A Deep Dive Into the Architecture That Powers Giantsoriginal ↗
27 Jul 2025
From Lag to Leading: A Deep Dive into Fixing a 2-Hour PostgreSQL Replication Lagoriginal ↗
23 Jul 2025
Taming PostgreSQL Replication Lag in Real-Time Blockchain Indexersoriginal ↗
10 Jul 2025
Understanding Source Code vs Bytecode in Move-Based Blockchainsoriginal ↗
7 May 2025
Demystifying API Gateway Patterns: Design Choices, Real-World Use Cases & When to Use Whatoriginal ↗
9 Apr 2025
Handling Large Datasets & High-Traffic Queries: Optimizing Pagination, Sorting & Filteringoriginal ↗
22 Feb 2025

2024

The Ultimate Git Command Guide: Streamline Your Development Workfloworiginal ↗
9 Jul 2024
Strings in JavaScript: An In-Depth Guideoriginal ↗
21 Jun 2024
Choosing Between Type and Interface in TypeScript: A Detailed Guideoriginal ↗
19 Jun 2024
Unveiling the Power of Descriptive Naming Conventions in JavaScriptoriginal ↗
29 May 2024
Navigating Your Career: Deciding Which Skills to Develop at Each Stageoriginal ↗
26 Apr 2024
What's New in Next.js 14original ↗
26 Feb 2024

2023

Linux Terminal Basics Commands:original ↗
20 Dec 2023
JavaScript ES6 Coding Conventionsoriginal ↗
19 Dec 2023
40 Best Practices for Writing Clean JavaScript, React, and Node.js Codeoriginal ↗
1 Sept 2023
Branching Guidelines and Conventionsoriginal ↗
24 Aug 2023
Sequelize using Postgres dialectoriginal ↗
7 Aug 2023
Clustering In NodeJsoriginal ↗
7 Aug 2023