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.

Troubleshooting PostgreSQL JOIN Performance: A Guide for Query Optimization

PostgreSQL environment is unique, so these guidelines should be adapted and tested according to your specific context. Regular monitoring and a thorough understanding of your data and query patterns are key to maintaining optimal JOIN performance.

[...]

Troubleshooting PostgreSQL Error 53300: TOO_MANY_CONNECTIONS

PostgreSQL Too Many Connections: Troubleshooting Error 53300

When you encounter the 53300: TOO_MANY_CONNECTIONS error in PostgreSQL, it indicates that your database has reached its maximum configured limit for simultaneous connections. This can happen due to high traffic, inefficient application design, or insufficient configuration settings.

[...]

Troubleshooting of MySQL Query Latency and Index Usage with eBPF

MySQL eBPF: Advanced Troubleshooting of Query Latency and Index Usage

Using eBPF (extended Berkeley Packet Filter) for troubleshooting MySQL query latency and index usage is a sophisticated technique that leverages Linux's advanced tracing capabilities. eBPF allows you to trace system and application-level metrics without significant performance overhead

[...]

GDPR-Compliant Data Obfuscation in PostgreSQL

PostgreSQL Data Obfuscation: GDPR-Compliant Implementation

Implementing data obfuscation in PostgreSQL to comply with the General Data Protection Regulation (GDPR) involves transforming sensitive data into a less sensitive form, a process that helps protect personal data while maintaining its usability.

[...]

Optimizing PostgreSQL Queries with Partial Indexes

PostgreSQL Partial Index: Step-by-Step Query Optimization Guide

Implementing partial indexes in PostgreSQL is an efficient way to optimize your database performance, especially when dealing with large tables with specific query patterns. Partial indexes are indexes built over a subset of a table, defined by a condition.

[...]