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.

PostgreSQL Error Handelling: Handling Errors in a Transaction Using Savepoint

In PostgreSQL, errors inside a transaction can also be handled using savepoints. A savepoint is a point within a transaction that can be rolled back, without rolling back the entire transaction. Here is an example […]

MyRocks Bloom Filter Offloading MyRocks and Storage Indexes

MyRocks is a storage engine for the MySQL database that uses RocksDB, a high-performance key-value store, as its underlying storage engine. By combining Bloom filter offloading and storage indexes, it is possible to further improve […]

OR Logic PostgreSQL Outer Joins: How It Influences Performance

Using OR logic in outer joins can have a significant impact on PostgreSQL performance, especially when joining large tables. Here are a few factors to consider: To mitigate the impact of OR logic on PostgreSQL […]

MySQL Correlated Subqueries Performance: Troubleshooting Guide

Correlated subqueries in MySQL can be slow because they require the subquery to be executed for each row in the outer query. This means that the subquery is executed repeatedly, and the results are used […]

PostgreSQL Delete Records: Optimally Deleting Rows Referenced from Another Table

When deleting records from a table that are referenced by other tables in PostgreSQL, there are several ways to ensure that the deletion is performed optimally and does not violate any foreign key constraints. Here […]

Anatomy of PostgreSQL I/O Subsystem

The I/O subsystem is a critical component of PostgreSQL, responsible for reading and writing data to and from disk. Here is an overview of the anatomy of PostgreSQL’s I/O subsystem: Monitoring the I/O subsystem is […]

Plan Cache Based Execution Statistics PostgreSQL: How It Is Implemented

Plan Cache Based Execution Statistics is a feature in PostgreSQL that collects and aggregates execution statistics for SQL statements that are stored in the plan cache. This allows users to monitor and analyze the performance […]

PostgreSQL Locks Explained – Understanding PostgreSQL MVCC

PostgreSQL provides three transaction isolation levels, which control the visibility of changes made by concurrent transactions. PostgreSQL Locks: PostgreSQL uses various types of locks to ensure data consistency in concurrent environments. Locks can influence performance […]

PostgreSQL Wait Events: How They Influence Performance

Understanding PostgreSQL Wait Statistics is critical for optimizing database performance. Wait Statistics provide insights into the resources that are being blocked and the time that is being spent waiting for those resources. Here’s an overview […]

pg_Stat_statements vacuum and analyze: Monitoring VACUUM and ANALYZE Performance

pg_stat_statements is a PostgreSQL extension that provides a detailed view of the SQL statements executed by the database server. It can be used to monitor the performance of VACUUM and ANALYZE operations by tracking the […]

The Data Transformation Company

Data Architecture, Engineering and Operations for SQL, NoSQL, NewSQL, Cloud Native Data Platforms, Analytics and AI