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 Internals

PostgreSQL Index Wildcard Explained

Index wildcard is a technique used in PostgreSQL to create an index on a partial string in a column, rather than indexing the entire column. This technique can improve query performance when searching for data […]
No Picture
PostgreSQL Performance

Troubleshooting PostgreSQL Query Performance

Monitoring query latency, wait events, and locks in PostgreSQL helps identify and diagnose performance bottlenecks. Here’s a guide on how to monitor these aspects: Here’s a sample query to gather information about locks, wait events, […]
No Picture
MySQL Performance

MySQL UNDO Operations: Tuning Guide

In MySQL, undo operations are used to provide transactional consistency and to allow for rolling back changes made to the database during a transaction. Undo operations are implemented in the InnoDB storage engine, which is […]
No Picture
MySQL Performance

MySQL Lock Contention: How to Reduce It

Reducing lock contention in MySQL involves implementing various techniques and strategies that help minimize the occurrence of lock-related performance issues. Here are some of the ways to reduce lock contention in MySQL: By implementing these […]
No Picture
PostgreSQL Performance

PostgreSQL Execution Plans: What to Look For

PostgreSQL execution plans PostgreSQL execution plans provide information on how the database intends to execute a given query. Understanding execution plans is crucial to identify performance issues and optimize query performance. Here are some of […]