_Aiden TranPosts Tagged with "Database"Columnar Database: When Reading 3 Columns Beats Reading the Whole Table, and Why Parquet Dominates AnalyticsDatabase, System Design, Backend, AWSJun 11, 2026Sequential Read: From read() to the Disk, and Why Postgres Sometimes Picks Seq Scan Over Your IndexDatabaseJun 8, 2026PostgreSQL Index: Why Indexes Speed Up Queries, And When Postgres Ignores ThemDatabaseMay 29, 2026PostgreSQL Partitioning: When One Big Table Becomes Many Small OnesDatabaseMay 26, 2026PostgreSQL Storage Internals: From Heap Files on Disk to Shared BuffersDatabaseMay 26, 2026Connection Pool: Why Opening a Database Connection Per Request Is WastefulBackend, Database, System DesignMay 4, 2026Table Bloat in PostgreSQL: Storage Optimization StrategiesDatabaseJan 25, 2026Solving the "Just Wrote It, Can't Read It" Problem: Read-Your-Writes Consistency & Session StickyDatabaseJan 14, 2026More tagsDevops (43)AWS (37)SAA (31)Database (8)System Design (13)Backend (12)Javascript (1)Storage (1)Distributed Systems (1)DNS (2)Cache (6)Data Structures (1)API (2)Networking (1)Shopify (1)Azure (1)Tips (1)🇻🇳Toggle theme