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.

Unlocking Success: Why Internet Companies Trust MinervaDB for Optimal Open Source Database Infrastructure Operations

MinervaDB Several internet companies—including startups, medium-sized enterprises, and large organizations—engage with MinervaDB for consultative support and 24/7 managed services of PostgreSQL, MySQL, and ClickHouse. They choose MinervaDB for several key reasons. MinervaDB’s expertise, consultative approach, […]

Troubleshooting Error Code 2013: Connection Lost Error in MySQL – 10 Reasons and Solution

MySQL Error Code 2013 The MySQL Error Code 2013 (CR_SERVER_LOST) indicates a connection lost error. Here are 10 possible reasons for this error and how to troubleshoot them: To troubleshoot Error Code 2013, it’s essential […]

Clustered Index Design considerations in PostgreSQL

In PostgreSQL, a clustered index works through a feature called “clustered table” or “clustered index scan.” It physically reorders a table’s rows based on the indexed column(s). This process directly determines how PostgreSQL organizes data […]

How is Process Memory Protection implemented in PostgreSQL?

Process Memory Protection in PostgreSQL Process memory protection in PostgreSQL is primarily implemented through the use of memory management techniques provided by the operating system. PostgreSQL relies on the underlying operating system’s memory management capabilities […]

How to influence cost based optimizer in PostgreSQL for performance?

PostgreSQL‘s cost-based optimizer (CBO) is responsible for determining the most efficient execution plan for a given query. To influence the CBO and improve performance, you can follow these tips: By following these tips, you can influence […]

The Comprehensive Guide to InnoDB Data Structures: B+Trees, Hash Indexes, and More

Data structures play a critical role in defining the efficiency and effectiveness of a database management system (DBMS). InnoDB, the default storage engine for MySQL, relies heavily on two types of data structures – B+Trees and […]

Solving Common InnoDB Performance Issues: A Comprehensive Guide

In the realm of MySQL database engines, InnoDB stands out as a powerful and widely used engine. It is renowned for its robustness, reliability, and performance. However, like all software, it is not exempt from […]

Demystifying PostgreSQL MVCC: Unlocking Concurrency Control in Your Database

Introduction: In the world of relational databases, PostgreSQL stands out as a robust and feature-rich option. Among its many powerful capabilities is the Multi-Version Concurrency Control (MVCC) system. While MVCC is an essential aspect of […]

Best Practices for Managing Locking in PostgreSQL to Improve Concurrency

PostgreSQL Locking Managing locking in PostgreSQL is crucial for improving concurrency and ensuring efficient data access in a multi-user environment. To achieve this, follow these best practices: Use Row-level Locking PostgreSQL offers different locking modes. […]

Understanding backup-related Waits happening to PostgreSQL

PostgreSQL Waits In PostgreSQL, backup-related waits occur when performing database backups with tools like pg_dump or pg_basebackup. These waits usually stem from I/O operations since the process involves reading data from disk and writing it […]

The Data Transformation Company

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