Tech Blog & Engineering Masterclasses

In-depth developer guides on V8 internals, Python architecture, SQL, Next.js, and placement drives.

✍️ Write Story

🌐 All Articles (39) 🚀 Backend & SaaS (0) 🐍 Python & Backend (5) 🚀 Django & Web Architecture (3) 🗄️ Database & SQL (2) 🧩 Data Structures & Algorithms (5) 🎯 Interview Prep & Database (12) 💼 Career & Git Roadmaps (4) 🎨 UI & Design Systems (1) ⚡ JavaScript & Engines (2) ⚛️ Frontend & Next.js (2) 🛠️ Developer Tooling & Compilers (3)

Kashinath Chavan • Database & SQL • Aug 19

PostgreSQL Advanced Patterns: JSONB Queries, Partial Indexes & Full-Text Search

PostgreSQL JSONB with GIN indexes delivers MongoDB-level document flexibility inside a relational database. Learn partial indexes, expression indexes, covering indexes, and full-text search with tsvector — the patterns used by Shopify and GitLab at scale.

⏱️ 4 min read 👁️ 2892 views 👏 362 claps

PostgreSQL Advanced Patterns: JSONB Queries, Partial Indexes & Full-Text Search

Kashinath Chavan • Database & SQL • Aug 16

PostgreSQL Query Optimization: Understanding B-Tree Indexes, EXPLAIN ANALYZE & Buffer Hits

Demystify query performance in PostgreSQL. Learn how sequential scans, index scans, bitmap heap scans, and memory work behind every high-speed SQL query.

⏱️ 1 min read 👁️ 259 views 👏 64 claps

Tech Blog & Engineering Masterclasses

PostgreSQL Advanced Patterns: JSONB Queries, Partial Indexes & Full-Text Search

PostgreSQL Query Optimization: Understanding B-Tree Indexes, EXPLAIN ANALYZE & Buffer Hits

Open on Desktop Browser