KKarthik Dwarakanath·Oct 13How I Doubled IO Performance: A Bottleneck Detective Story using AI During the development of our User space block management layer—a storage engine layer that uses dynamic B-tree metadata lookups for block allocation—I encountered a massive performance gap in sequent7 min read·perfguru.hashnode.dev
Kkiran sabne·Sep 18PostgreSQL Nested Loop: When Is It Actually a Problem?When a Postgres Nested Loop join is fine vs. when outer rows × inner loops actually costs you — real EXPLAIN ANALYZE examples.3 min read·kiransabne.dev1
Kkiran sabne·Sep 18PostgreSQL Index Bloat: Why It Happens and How to Fix ItWhy PostgreSQL indexes bloat even after VACUUM, how to measure it with pgstatindex, and when to use REINDEX CONCURRENTLY or pg_repack to fix it.6 min read·kiransabne.dev
PPranjal Verma·Aug 12Spark Performance Tuning Interview Prep GuideMaster Spark tuning for interviews: shuffle, partitioning, caching, joins, AQE, memory, Spark UI, and production scenarios for data engineering roles.13 min read·blog.pvcodes.in
RRakesh Kishore·Jul 6The ASYNC_NETWORK_IO Myth: Why Your Database Is Waiting on Slow Application CodeUnclogging the data consumption pipeline: Why the network team isn't to blame for network wait states, how data buffers choke processing threads, and how to accelerate streaming throughput.7 min read·tunedinstance.com
RRakesh Kishore·Jul 2UNION vs. UNION ALL: How Hidden Sort Operators Slow Down Your Combined DatasetsUnmasking the duplicate check penalty: Why combining queries can trigger unexpected disk grinding, how to trace performance plan warnings, and when to drop the distinct filter safely.7 min read·tunedinstance.com
RRakesh Kishore·Jul 1Hidden CPU Burn: How Scalar User-Defined Functions Trap Your Queries in RBAR LoopsUnwrapping row-by-row bottlenecks: Why modular code kills database performance, how to track hidden UDF execution penalties, and how to convert functions into high-speed inline expressions.6 min read·tunedinstance.com
RRakesh Kishore·Jun 30The Local Variable Trick: How to Stabilize Stored Procedures and Bypass Parameter SniffingTuning execution plans at the code level: Why hiding parameter values from the query optimizer stops performance spikes and creates rock-solid query consistency.7 min read·tunedinstance.com
RRakesh Kishore·Jun 27Mass Data Imports: How to Stop Transaction Log Bloat During Bulk InsertsUnclogging the ETL pipeline: Why inserting millions of rows crashes your drive storage, how to unlock minimal logging, and how to load datasets at hardware line speeds.7 min read·tunedinstance.com
RRakesh Kishore·Jun 27SQL Server Deadlocks: How to Track Down Error 1205 and Stop Query CollisionsBreaking the ultimate database gridlock: Why transactions violently collide, how to extract hidden XML deadlock graphs, and how to rewrite code patterns to eliminate victim states.7 min read·tunedinstance.com1
