Krishnasrivastava·Oct 8B-Trees Under the Hood: How PostgreSQL Indexes Actually WorkMany of you know that SQL based databases such as postgress etc. use B-Tree for storing indexes , but how many of you really know the…
InTowards DevbyCodeTalks·Sep 14🔥 Your PostgreSQL Database Isn’t Slow — Your Indexes Are Wrong“We doubled the database CPU. The API was still slow. One index fixed the real problem.”A response icon1
mohamed anwer·May 3SQL Server Views — From Basics to Advanced (How I Actually Understand It)Content of this blog
tech_hi_tech_dosto·Mar 28System Design -Sharding, Partitioning, Indexing, and all about databasesMental model — a big square(map) having different colors , when we cut it and rejoin it using tape — sharding and when we hide it and…
