DEV Community

Shiv Iyer profile picture

Shiv Iyer

Founder CEO of #MinervaDB #ChistaDATA #MySQL #PostgreSQL #MongoDB #InnoDB #MariaDB #ClickHouse #Linux #Entreprenuer #Investor #Startup #OpenSource #BigData #Analytics #SRE #AI #ML #DevOps #OLTP #OLAP

Location San Francisco Joined Joined on  Personal website https://minervadb.xyz github website

Work

Founder and CEO at MinervaDB

Common pitfalls and solutions for mysqldump/xtrabackup-based SSTs

Common pitfalls and solutions for mysqldump/xtrabackup-based SSTs

Comments
2 min read
Performance Tips for Developers Using Postgres and pgvector

Performance Tips for Developers Using Postgres and pgvector

5
Comments
3 min read
What are some practical use cases for the MERGE command in data warehousing?

What are some practical use cases for the MERGE command in data warehousing?

Comments
3 min read
Easier Upgrades and Image Management for Postgres in Kubernetes

Easier Upgrades and Image Management for Postgres in Kubernetes

Comments
3 min read
Choice of Table Column Types and Order When Migrating to PostgreSQL

Choice of Table Column Types and Order When Migrating to PostgreSQL

2
Comments
2 min read
How can I use the MongoDB explain plan to troubleshoot query performance

How can I use the MongoDB explain plan to troubleshoot query performance

Comments
2 min read
What are the performance matrices used in MongoDB Query Performance Troubleshooting?

What are the performance matrices used in MongoDB Query Performance Troubleshooting?

Comments
3 min read
How can I optimize the performance of an aggregation pipeline in MongoDB

How can I optimize the performance of an aggregation pipeline in MongoDB

Comments
2 min read
How to implement an aggregation framework in MongoDB?

How to implement an aggregation framework in MongoDB?

Comments
3 min read
How to build multi-tenancy in PostgreSQL for developing SaaS applications?

How to build multi-tenancy in PostgreSQL for developing SaaS applications?

Comments
4 min read
How to build multi-tenancy in PostgreSQL for developing SaaS applications?

How to build multi-tenancy in PostgreSQL for developing SaaS applications?

1
Comments
4 min read
What are the benefits of using bounded quantifiers in regex

What are the benefits of using bounded quantifiers in regex

Comments
1 min read
Effective Strategies for Troubleshooting MongoDB Wait Events in Long-Running Query Operations

Effective Strategies for Troubleshooting MongoDB Wait Events in Long-Running Query Operations

1
Comments
3 min read
Proactive Monitoring and Anomaly Detection in MySQL Server Performance

Proactive Monitoring and Anomaly Detection in MySQL Server Performance

2
Comments
2 min read
How to use Kimball Helper Table(PostgreSQL) in Modern Banking for Performance Analysis and Monetisation?

How to use Kimball Helper Table(PostgreSQL) in Modern Banking for Performance Analysis and Monetisation?

1
Comments
3 min read
How does Wave Analytics handle data from external databases in PostgreSQL?

How does Wave Analytics handle data from external databases in PostgreSQL?

Comments
3 min read
Optimizing ClickHouse Performance: Strategies for Identifying and Reducing Over-fetching in SELECT Queries

Optimizing ClickHouse Performance: Strategies for Identifying and Reducing Over-fetching in SELECT Queries

2
Comments
3 min read
Optimizing ClickHouse Performance: Strategies for Identifying and Reducing Over-fetching in SELECT Queries

Optimizing ClickHouse Performance: Strategies for Identifying and Reducing Over-fetching in SELECT Queries

Comments
3 min read
Tips and Tricks for Troubleshooting ClickHouse Wait Events

Tips and Tricks for Troubleshooting ClickHouse Wait Events

1
Comments
2 min read
Impact of Fragmented PostgreSQL Infrastructure on Performance, Scalability, and Security

Impact of Fragmented PostgreSQL Infrastructure on Performance, Scalability, and Security

Comments
3 min read
Configuring Statement Timeout in PostgreSQL for Optimal Performance Management

Configuring Statement Timeout in PostgreSQL for Optimal Performance Management

21
Comments
2 min read
Optimizing PostgreSQL Performance: Navigating the Use of Bind Variables in Version 16

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

3
Comments
3 min read
Effective Annotating of Strace Output for MySQL Performance Troubleshooting

Effective Annotating of Strace Output for MySQL Performance Troubleshooting

1
Comments
4 min read
Implementing Index Recommendation by PostgreSQL Optimizer

Implementing Index Recommendation by PostgreSQL Optimizer

3
Comments
3 min read
Boosting PostgreSQL Performance: Configuring Efficient Caching for Optimal Query Response

Boosting PostgreSQL Performance: Configuring Efficient Caching for Optimal Query Response

3
Comments
2 min read
Strategic Indexing: Making Informed Column Indexing Decisions in PostgreSQL

Strategic Indexing: Making Informed Column Indexing Decisions in PostgreSQL

Comments
3 min read
Mastering Performance Troubleshooting with sys.dm_exec_requests in Azure SQL

Mastering Performance Troubleshooting with sys.dm_exec_requests in Azure SQL

6
Comments
2 min read
Exploring PostgreSQL Joins: A Comprehensive Guide Using Sales Data and Product Information

Exploring PostgreSQL Joins: A Comprehensive Guide Using Sales Data and Product Information

Comments
3 min read
Effective Strategies for Troubleshooting and Resolving 'Failure to Find WAL Records' Errors in PostgreSQL

Effective Strategies for Troubleshooting and Resolving 'Failure to Find WAL Records' Errors in PostgreSQL

1
Comments
2 min read
The Indispensable Role of Database Architects and Engineers in Optimizing DBaaS and RDS Environments

The Indispensable Role of Database Architects and Engineers in Optimizing DBaaS and RDS Environments

2
Comments
2 min read
Optimizing PostgreSQL Performance: A Comprehensive Guide to Rowstore Index Implementation and Tuning

Optimizing PostgreSQL Performance: A Comprehensive Guide to Rowstore Index Implementation and Tuning

1
Comments
3 min read
Mastering PostgreSQL Performance: Key Impacts of autovacuum_vacuum_scale_factor Tuning

Mastering PostgreSQL Performance: Key Impacts of autovacuum_vacuum_scale_factor Tuning

Comments
2 min read
Mastering Bound Queries in PostgreSQL: A Step-by-Step Guide with Examples

Mastering Bound Queries in PostgreSQL: A Step-by-Step Guide with Examples

Comments
2 min read
Strategies for Adaptive Hash Indexing in MySQL: To Enable or Disable?

Strategies for Adaptive Hash Indexing in MySQL: To Enable or Disable?

Comments
2 min read
Enhancing Write Performance: Key Strategies for Optimizing the InnoDB Buffer Pool in MySQL

Enhancing Write Performance: Key Strategies for Optimizing the InnoDB Buffer Pool in MySQL

Comments
3 min read
How to optmize PostgreSQL query performance tuning effective_cache_size ?

How to optmize PostgreSQL query performance tuning effective_cache_size ?

Comments
2 min read
Tips and Tricks for Tuning PostgreSQL Thread Cache Performance

Tips and Tricks for Tuning PostgreSQL Thread Cache Performance

1
Comments
3 min read
Troubleshooting SELECT * queries in PostgreSQL

Troubleshooting SELECT * queries in PostgreSQL

Comments
2 min read
Optimizing SQL Server Performance: A Guide to Using sys.dm_exec_query_stats for Query Troubleshooting

Optimizing SQL Server Performance: A Guide to Using sys.dm_exec_query_stats for Query Troubleshooting

Comments
2 min read
Mastering Query Store for SQL Server Performance Troubleshooting: A Step-by-Step Guide

Mastering Query Store for SQL Server Performance Troubleshooting: A Step-by-Step Guide

Comments
3 min read
Troubleshooting ClickHouse Performance from Execution Plan

Troubleshooting ClickHouse Performance from Execution Plan

1
Comments
2 min read
Using DBMS_SQL for Dynamic SQL Execution in EDB Postgres Advanced Server 16

Using DBMS_SQL for Dynamic SQL Execution in EDB Postgres Advanced Server 16

Comments
2 min read
Linear Trees in InnoDB

Linear Trees in InnoDB

Comments
3 min read
SHOW ENGINE INNODB STATUS\G

SHOW ENGINE INNODB STATUS\G

Comments
2 min read
Troubleshooting Fragmented Indexes in PostgreSQL

Troubleshooting Fragmented Indexes in PostgreSQL

2
Comments
3 min read
How misconfiguration of autovacuum_vacuum_scale_factor in PostgreSQL can negatively impact on performance?

How misconfiguration of autovacuum_vacuum_scale_factor in PostgreSQL can negatively impact on performance?

2
Comments
2 min read
Implementing Columnstore Indexes in PostgreSQL with the cstore_fdw Extension

Implementing Columnstore Indexes in PostgreSQL with the cstore_fdw Extension

2
Comments
2 min read
How to encrypt MySQL data with keys

How to encrypt MySQL data with keys

Comments
2 min read
Impact of Faster CPUs vs. More CPUs on ClickHouse Performance

Impact of Faster CPUs vs. More CPUs on ClickHouse Performance

1
Comments
1 min read
Tips and Tricks for Tuning PostgreSQL Thread Cache Performance

Tips and Tricks for Tuning PostgreSQL Thread Cache Performance

Comments
3 min read
Troubleshooting SQL statments with weak selectivity in ClickHouse

Troubleshooting SQL statments with weak selectivity in ClickHouse

Comments
2 min read
How does the wrong checkpointing configuration in PostgreSQL affect the performance?

How does the wrong checkpointing configuration in PostgreSQL affect the performance?

5
Comments
2 min read
Harnessing MySQL Document Store: A Guide to Transforming Documents into Data

Harnessing MySQL Document Store: A Guide to Transforming Documents into Data

1
Comments
2 min read
Step-by-step implementation Filesystem Snapshots in PostgreSQL

Step-by-step implementation Filesystem Snapshots in PostgreSQL

4
Comments
2 min read
Resolving PostgreSQL Error 53300: TOO_MANY_CONNECTIONS - A Comprehensive Troubleshooting and Optimization Guide

Resolving PostgreSQL Error 53300: TOO_MANY_CONNECTIONS - A Comprehensive Troubleshooting and Optimization Guide

1
Comments
2 min read
Python Script for Early Detection of Data Corruption in ClickHouse Databases

Python Script for Early Detection of Data Corruption in ClickHouse Databases

Comments
2 min read
Mastering MySQL Performance: Advanced Counters and Linux Metrics with Expert Scripts

Mastering MySQL Performance: Advanced Counters and Linux Metrics with Expert Scripts

Comments
2 min read
MySqlException (0x80004005): The Command Timeout expired before the operation completed

MySqlException (0x80004005): The Command Timeout expired before the operation completed

1
Comments
2 min read
Tips and Tricks for isolating long running queries in MySQL

Tips and Tricks for isolating long running queries in MySQL

1
Comments
2 min read
Tuning InnoDB for efficient compression

Tuning InnoDB for efficient compression

1
Comments
2 min read
loading...