Kiran Sabne — PostgreSQL, AI & Backend Engineering at Scale

How do you write efficient pagination for millions of rows?

Efficient pagination is absolutely critical when dealing with millions of rows in PostgreSQL — especially if you care about performance, index usage, and UX for APIs or UI pages. 1. OFFSET/LIMIT Pagin

Jan 9, 20263 min read

PostgreSQL Parameter Tuning for 100M+ Rows

When you’re running PostgreSQL with 100M+ rows, the difference between “it works” and “it flies” is all about tuning—but not the generic, copy-paste advice you get everywhere. Here’s the advanced, bat

Jan 4, 20264 min read

Understanding and Solving Cache Stampede: The Invisible Threat to Databases

Imagine this: Your high-traffic app is humming along smoothly. Most data requests are being served instantly from Redis or other, blazing-fast cache layer. But then — a cache key expires, and within milliseconds, 10,000 clients hit your backend at on...

Jan 3, 20264 min read

Create a Semantic Search API with FastAPI, Sentence-BERT, and PostgreSQL pgvector

In this post, I’ll walk you through how I built a semantic similarity search API using FastAPI, Sentence-BERT (SBERT), and PostgreSQL with the pgvector extension.This project began as a proof of concept (POC) to explore how seamlessly we can integrat...

Oct 14, 20254 min read

PostgreSQL Indexing: When BRIN Is a Better Choice Than B-Tree

If you’re indexing huge, append-only tables with naturally ordered data — BRIN can give you massive performance and space benefits compared to B-Tree. What is a BRIN Index? BRIN = Block Range Index A BRIN index doesn't index every row, unlike B-Tree....

Oct 4, 20254 min read

MongoDB Locking Explained: Summary of Concurrency and Locking Strategies

When working with high-concurrency workloads in MongoDB, understanding how locking and concurrency control work is essential to maintain performance and data integrity. Here’s a quick overview of the core ideas: Key Highlights: Document-Level Lockin...

Jul 19, 20251 min read

Cracking the SQL Interview: Real Questions and PostgreSQL Internals You Should Know

Over the past few months since the start of new year, I’ve been actively interviewing for technical roles, and each conversation proved to be both challenging and rewarding. In this post, I’ll share some of the SQL questions I was asked, along with d...

Jul 12, 20256 min read

Using Go's Context Package: Managing Concurrency and Lifecycle in Applications"

In Go programming, the context package is widely used to manage deadlines, cancellations, and other request-scoped values across API boundaries and go-routines. It provides a standardised way to pass contextual information and control the lifecycle o...

Nov 22, 20246 min read

Utilize Table Inheritance in PostgreSQL for a More Efficient Database Design

In every application development process, we often encounter scenarios where entities share common attributes while also possessing unique characteristics. We manage these parent-child-like relationships between entities using inheritance logic in ou...

May 29, 20234 min read

Command Palette

Latest articles