Dilip Kumar

EDB Principal Engineer / Senior Engineering Manager

Dilip works as Associate Database Architect at EDB.  He is currently working on database internals and associated with the team developing undo based database storage engine for PostgreSQL open source.  

Dilip has been working on PostgreSQL code since 2010 and he is a PostgreSQL contributor.  The major work done by him is parallel-query and performance improvements for multi-core machines.  In the past, he has worked on various database projects including integrating in-memory storage engine with PostgreSQL.

Read Blogs

Technical Blog

How Postgres Workload Reports Help Optimize Database Operations

EDB’s Postgres Workload Reports help DBAs with data retrieval and database operations, enhancing Postgres server performance and troubleshooting.
Postgres Tutorials

The Life of a Bug: From Customer Escalation to PostgreSQL commit

In the intricate world of software development, bugs are the elusive creatures that can disrupt the smooth operation of applications and systems. At times my co-journey with a bug begins with a customer escalation, setting off a series of events leading to investigation, resolution, and ultimately, a more robust software ecosystem. Let's delve into the life of one such bug, tracing its path from customer escalation to a patch release and ultimately the redesign of a critical Postgres subsystem.
Postgres Tutorials

EDB Tutorial: How To Get the Most Out of EDB Query Advisor

Enterprise-class databases require DBAs who are responsible for maximizing query performance. Therefore, when it comes to large scale deployment of databases, minimizing the work of DBA is important.
Postgres Tutorials

What is Parallel Vacuum in PostgreSQL 13

In PostgreSQL, we already support parallelism of a SQL query which leverages multiple cores to execute the query faster. Vacuum is one of the most critical utility operations which helps in controlling bloat, one of the major problems for PostgreSQL DBAs. So, vacuum needs to run really fast to reduce the bloat as early as possible. In PG13, parallel vacuum is introduced which allows for parallel vacuuming of multiple indexes corresponding to a single table.
EDB Labs

Configurable LZ4 TOAST compression

This article introduces configurable lz4 TOAST compression feature which will be available in PostgreSQL version 14, and demonstrates its usage.
EDB Labs

Logical Decoding of Large In-Progress Transactions in PostgreSQL

Logical replication in PostgreSQL is a publish-subscribe model, where a subscriber node can subscribe to a publisher and receive logical changes from the publisher in real time