Articles by Shiv Iyer

About Shiv Iyer
Open Source Database Systems Engineer with a deep understanding of Optimizer Internals, Performance Engineering, Scalability and Data SRE. Shiv currently is the Founder, Investor, Board Member and CEO of multiple Database Systems Infrastructure Operations companies in the Transaction Processing Computing and ColumnStores ecosystem. He is also a frequent speaker in open source software conferences globally.
Website Facebook Twitter LinkedIn
No Picture
PostgreSQL Performance

PostgreSQL Index Bloat: Analysis and Detection

Introduction: Index bloat can significantly impact the performance and storage efficiency of a PostgreSQL database. Therefore, to identify and understand the extent of index bloat, we can use the SQL query provided below. In this […]
No Picture
InnoDB

InnoDB Flush Locks: Troubleshooting Guide

InnoDB Flush Locks InnoDB writes data to disk by using a method called “fuzzy checkpointing,” which spreads out writes to avoid sudden I/O bursts and maintain performance.  However, under certain circumstances, such as when there […]
No Picture
InnoDB

Tuning InnoDB history list performance

Tuning the InnoDB history list performance involves adjusting various parameters related to the purge process. The key parameters that can be tuned to optimize the history list performance in InnoDB are: To tune these parameters, follow […]