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.

How large Indexes corrupt PostgreSQL Execution Plans?

Large indexes in PostgreSQL can corrupt execution plans by causing the query planner to choose suboptimal plans due to the cost of scanning the large index. When the size of an index exceeds the effective_cache_size […]

How to reduce replication lag with IO concurrency in PostgreSQL 15?

PostgreSQL 15 introduced a new feature called “asynchronous commit”, which can help reduce replication lag by allowing multiple transactions to be committed concurrently. This feature works by allowing the server to continue processing new transactions […]

Troubleshooting PostgreSQL Thread Contention

Thread contention in PostgreSQL occurs when multiple threads are competing for the same resources, such as CPU time, disk I/O, or database locks. This can lead to performance degradation, slower response times, and even database […]

How do we Troubleshoot PostgreSQL Contention in MinervaDB?

In PostgreSQL, the catalog tables are system tables that store metadata information about the database objects such as tables, indexes, functions, and users. The catalog tables can be used to troubleshoot contention issues by providing […]

Understanding Shared Buffers Implementation in PostgreSQL

In PostgreSQL, shared buffers serve as the shared memory pool used to cache data pages in memory to improve read performance. Whenever a query needs to access data, it checks if the required pages are […]

Understanding MariaDB Indexing

Indexes in MariaDB are implemented as data structures that allow faster data retrieval from tables. There are several types of indexes available in MariaDB, each with its own characteristics and use cases. Here’s an overview […]

Why the world’s largest Independent Mobile Ad. Network used MinervaDB MyRocks Managed Services for implementing Fraud Management System?

The fraudulent traffic and clicks can result in significant revenue loss for mobile ad networks. Advertisers pay for ad impressions and clicks that are not actually driving real business value, and the mobile ad network […]

The Data Transformation Company

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