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 Performance

Inspecting PostgreSQL Locks

Inspecting PostgreSQL Locks Inspecting PostgreSQL locks can be done using the pg_locks view in the system catalog. This view displays information about all currently held and awaited locks. The columns in this view include the [...]
No Picture
MySQL DBA

How to implement master key rotation in MySQL?

How to implement master key rotation in MySQL? Master key rotation in MySQL can be implemented using the built-in InnoDB encryption feature or using third-party tools. Here is a general overview of the steps involved [...]
No Picture
PostgreSQL Performance

How NULL values in PostgreSQL affect performance?

How NULL values in PostgreSQL affect performance? NULL values in PostgreSQL can have an impact on the performance of queries and calculations, depending on how they are handled. Indexes: Indexes on columns that contain NULL [...]
No Picture
PostgreSQL Performance

PostgreSQL Index Maintenance and Repair

PostgreSQL Index Maintenance and Repair Index maintenance and repair are important tasks that help to keep the database running at optimal performance. In PostgreSQL, there are several methods for performing index maintenance and repair: REINDEX: [...]
No Picture
PostgreSQL Performance

Analyzing PostgreSQL with strace

Analyzing PostgreSQL with strace strace is a powerful Linux tool that allows you to trace system calls and signals of a running process. It can be used to analyze the behavior of a PostgreSQL server [...]
No Picture
PostgreSQL Performance

Tuning Linux for PostgreSQL

Tuning Linux for PostgreSQL Tuning Linux for PostgreSQL performance can involve several steps. Here are some general steps to take: Optimize kernel parameters: Make sure the kernel is configured for optimal performance for PostgreSQL. This [...]
No Picture
PostgreSQL Performance

How to tune a slow query in PostgreSQL?

How to tune a slow query in PostgreSQL? Tuning a slow query in PostgreSQL can involve several steps. Here are some general steps to take: Identify the slow query: Use the pg_stat_activity view to see [...]