--- title: "#performance-tuning articles | Hashnode" description: "Explore 71 articles tagged #performance-tuning on Hashnode. Tutorials, guides, and how-tos from the community." url: "https://hashnode.com/tag/performance-tuning" --- Tag # #performance-tuning 71 posts · 6 followers [Karthik Dwarakanath](https://hashnode.com/@perfguru) · [Oct 13](https://hashnode.com/posts/how-i-doubled-io-performance-a-bottleneck-detective-story-using-ai/6acea05b48f5a8d5b7d70ca2) ### [How I Doubled IO Performance: A Bottleneck Detective Story using AI](https://perfguru.hashnode.dev/how-i-doubled-io-performance-a-bottleneck-detective-story-using-ai?utm_source=hashnode&utm_medium=feed) 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 sequent 7 min read · [perfguru.hashnode.dev](https://perfguru.hashnode.dev/how-i-doubled-io-performance-a-bottleneck-detective-story-using-ai?utm_source=hashnode&utm_medium=feed) [kiran sabne](https://hashnode.com/@kiransabne) · [Sep 18](https://hashnode.com/posts/postgresql-nested-loop-when-is-it-actually-a-problem/6aad16149e5b1cc05dd4d181) ### [PostgreSQL Nested Loop: When Is It Actually a Problem?](https://kiransabne.dev/postgresql-nested-loop-when-is-it-actually-a-problem?utm_source=hashnode&utm_medium=feed) 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.dev](https://kiransabne.dev/postgresql-nested-loop-when-is-it-actually-a-problem?utm_source=hashnode&utm_medium=feed) [kiran sabne](https://hashnode.com/@kiransabne) · [Sep 18](https://hashnode.com/posts/postgresql-index-bloat-why-it-happens-and-how-to-fix-it/6aacdb14c88db9c85cde799f) ### [PostgreSQL Index Bloat: Why It Happens and How to Fix It](https://kiransabne.dev/postgresql-index-bloat-why-it-happens-and-how-to-fix-it?utm_source=hashnode&utm_medium=feed) Why 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](https://kiransabne.dev/postgresql-index-bloat-why-it-happens-and-how-to-fix-it?utm_source=hashnode&utm_medium=feed) [Pranjal Verma](https://hashnode.com/@pvcodes) · [Aug 12](https://hashnode.com/posts/spark-performance-tuning-interview-prep-guide/6a7c3a02c4b28467692fba66) ### [Spark Performance Tuning Interview Prep Guide](https://blog.pvcodes.in/spark-performance-tuning-interview-prep-guide?utm_source=hashnode&utm_medium=feed) Master 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](https://blog.pvcodes.in/spark-performance-tuning-interview-prep-guide?utm_source=hashnode&utm_medium=feed) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jul 6](https://hashnode.com/posts/sql-server-async-network-io-wait-type-fix/6a4b77811905d812dd690018) ### [The ASYNC\_NETWORK\_IO Myth: Why Your Database Is Waiting on Slow Application Code](https://tunedinstance.com/sql-server-async-network-io-wait-type-fix?utm_source=hashnode&utm_medium=feed) Unclogging 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](https://tunedinstance.com/sql-server-async-network-io-wait-type-fix?utm_source=hashnode&utm_medium=feed) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jul 2](https://hashnode.com/posts/union-vs-union-all-how-hidden-sort-operators-slow-down-your-combined-datasets/6a45ab7eaa47703809ba593c) ### [UNION vs. UNION ALL: How Hidden Sort Operators Slow Down Your Combined Datasets](https://tunedinstance.com/union-vs-union-all-how-hidden-sort-operators-slow-down-your-combined-datasets?utm_source=hashnode&utm_medium=feed) Unmasking 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](https://tunedinstance.com/union-vs-union-all-how-hidden-sort-operators-slow-down-your-combined-datasets?utm_source=hashnode&utm_medium=feed) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jul 1](https://hashnode.com/posts/hidden-cpu-burn-how-scalar-user-defined-functions-trap-your-queries-in-rbar-loops/6a4559d98141cde67a842b91) ### [Hidden CPU Burn: How Scalar User-Defined Functions Trap Your Queries in RBAR Loops](https://tunedinstance.com/hidden-cpu-burn-how-scalar-user-defined-functions-trap-your-queries-in-rbar-loops?utm_source=hashnode&utm_medium=feed) Unwrapping 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](https://tunedinstance.com/hidden-cpu-burn-how-scalar-user-defined-functions-trap-your-queries-in-rbar-loops?utm_source=hashnode&utm_medium=feed) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 30](https://hashnode.com/posts/the-local-variable-trick-how-to-stabilize-stored-procedures-and-bypass-parameter-sniffing/6a43ebc9eb3d2d20c1c66c25) ### [The Local Variable Trick: How to Stabilize Stored Procedures and Bypass Parameter Sniffing](https://tunedinstance.com/the-local-variable-trick-how-to-stabilize-stored-procedures-and-bypass-parameter-sniffing?utm_source=hashnode&utm_medium=feed) Tuning 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](https://tunedinstance.com/the-local-variable-trick-how-to-stabilize-stored-procedures-and-bypass-parameter-sniffing?utm_source=hashnode&utm_medium=feed) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 27](https://hashnode.com/posts/mass-data-imports-how-to-stop-transaction-log-bloat-during-bulk-inserts/6a40177efcbd311cf8d23c54) ### [Mass Data Imports: How to Stop Transaction Log Bloat During Bulk Inserts](https://tunedinstance.com/mass-data-imports-how-to-stop-transaction-log-bloat-during-bulk-inserts?utm_source=hashnode&utm_medium=feed) Unclogging 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](https://tunedinstance.com/mass-data-imports-how-to-stop-transaction-log-bloat-during-bulk-inserts?utm_source=hashnode&utm_medium=feed) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 27](https://hashnode.com/posts/sql-server-deadlocks-how-to-track-down-error-1205-and-stop-query-collisions/6a4017a145aa485e4880058b) ### [SQL Server Deadlocks: How to Track Down Error 1205 and Stop Query Collisions](https://tunedinstance.com/sql-server-deadlocks-how-to-track-down-error-1205-and-stop-query-collisions?utm_source=hashnode&utm_medium=feed) Breaking 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.com](https://tunedinstance.com/sql-server-deadlocks-how-to-track-down-error-1205-and-stop-query-collisions?utm_source=hashnode&utm_medium=feed)