Why SQL Pagination With Offset is Slow and How to Optimize It
Learn why using OFFSET for pagination harms performance and discover efficient alternatives like keyset pagination.
Database Sharding and Consistent Hashing Explained
A deep dive into database sharding, consistent hashing, and their practical implementation using Postgres and NodeJS.
PostgreSQL Partitioning – Real-World Lessons from Hussein's Database Lectures
Detailed notes on horizontal partitioning from Hussein's lecture series. Includes real PostgreSQL examples, performance tips, automation scripts, and how partitions improve query speed.
B+ Trees vs B-Trees: How Database Indexing Really Works
Why Uber abandoned PostgreSQL's UUID indexes and how linked leaf nodes solve range query nightmares.
Comprehensive Database Indexing & Performance Notes
Detailed personal notes covering clustered/non-clustered indexes, composite indexes, UUID performance, bitmap scans, and billion-row table strategies.
Database Performance Deep Dive: UUIDs, Bloom Filters, Indexes & Scaling
Lecture notes covering UUID impacts on B+Trees, Bloom filters, SQL Server index design, billion-row table strategies, and transaction costs.
Row vs Column Databases: How Your Data Storage Choices Make or Break Performance
Why do analytics queries crawl while transactions blaze? We break down row vs column storage, indexes, and the hidden world of database pages.
Understanding Database Consistency in Transactions Day 2
This note summarizes a lecture on consistency in database systems, covering types of consistency, eventual consistency in distributed systems, and isolation levels that help maintain reliable data states.
105 post articles, 14 pages.