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.

Optimizing PostgreSQL: A Guide to Troubleshooting Long-Running Queries and Wait Events

Troubleshooting long-running queries in PostgreSQL and identifying wait events, along with insights into application and session operations, involves several steps. This process helps in pinpointing the root cause of performance issues and in formulating appropriate […]

Implementing the Materialized Path Model in PostgreSQL: A Step-by-Step Guide

The Materialized Path model is a strategy for representing hierarchical data within a relational database system like PostgreSQL. It involves storing the entire path to a node within a tree as a single column value […]

Addressing Performance Bottlenecks in UPDATE and DELETE Intensive PostgreSQL Applications

PostgreSQL Performance Bottlenecks Applications with heavy UPDATE and DELETE operations can become epicenters of PostgreSQL performance bottlenecks, even with optimal indexing in place. This is due to several underlying factors associated with how PostgreSQL manages […]

Key Considerations for Optimizing and Managing PostgreSQL Indexes

PostgreSQL Index Optimization PostgreSQL index optimization is crucial for enhancing database performance, enabling faster record retrieval by efficiently locating rows in a table. Several key factors influence the effectiveness and performance of indexes in PostgreSQL: […]

Identifying Performance Bottlenecks: Assessing IO Subsystem Reads in MySQL

MySQL IO Subsystem Performance Detecting when the IO subsystem reads are struggling in MySQL involves observing several key performance indicators that could suggest the disk IO is becoming a bottleneck. Here are steps and methods […]

Optimizing PostgreSQL Performance: Navigating the Use of Bind Variables in PostgreSQL 16

In PostgreSQL, bind variables, also known as parameterized queries or prepared statements, are widely used to execute SQL queries more efficiently and securely. By separating the query structure from the data values, bind variables help […]

Efficient Integration of PostgreSQL 16 with LDAP: Best Practices and Tips

PostgreSQL 16 LDAP Integration Integrating PostgreSQL with LDAP not only centralizes user authentication but also simplifies access management across database instances. As a result, this approach enhances consistency while significantly reducing administrative effort. Furthermore, PostgreSQL [...]

How to define and capture Baselines in PostgreSQL Performance Troubleshooting?

Defining and capturing baselines plays a vital role in PostgreSQL performance troubleshooting. Baselines serve as a benchmark for normal performance metrics, offering a clear point of reference. By establishing these metrics, you can compare current [...]

Exploring Alternatives to SQL Server Query Store in PostgreSQL

PostgreSQL Query Performance Alternatives In PostgreSQL, the pg_stat_statements extension serves as the closest alternative to SQL Server’s Query Store. Specifically, it captures critical query performance metrics, such as execution counts, total time, and query text. […]

Understanding the Internal Locking Hierarchy and Mechanisms in PostgreSQL

In PostgreSQL, the locking mechanism is crucial for concurrency control, ensuring data integrity and consistency by preventing simultaneous incompatible operations. PostgreSQL employs a variety of lock types that operate at different levels of granularity, from […]