Ashutosh Bapat

Principal SDE, Manager

Ashutosh Bapat is Principal SDE, Manager at EDB, where he is currently working on EDB Postgres Distributed. He specializes in database internals, partitioning, query optimization, logical replication and BDR.

Ashutosh has been working in database internals development for more than 17 years. After completing masters from IIT Bombay, he started working with Sybase's ASE. He has primarily worked with distributed database systems; shared disk as well as shared nothing architectures. He was part of the Postgres-XC team. He has contributed features in the areas of partitioning, query optimization, FDW to open source PostgreSQL.

Read Blogs

EDB Labs

Partition-wise Joins: “Divide and Conquer" for Joins Between Partitioned Table

Unlike inheritance-based partitioning, declarative partitioning introduced in PostgreSQL 10 leaves nothing to infer about how the data is divided into partitions. PostgreSQL 11's query optimizer is gearing up to take advantage of this "no-inference" representation. The first one that got committed was basic partition-wise join. What is partition-wise join? A join between two similarly partitioned...
EDB Labs

Postgres Partition: Upgrade your Partitioning from Inheritance to Declarative

Before PostgreSQL 10, Postgres users partitioned their data using inheritance based partitioning. The method used constraints to define the partitions and rules or triggers to route the data to appropriate partition.
Product Updates

Next Generation Routing in EDB Postgres Distributed 5.0

The basic building block of a PGD deployment is a node group or, simply, a group. In a geo-distributed PGD cluster, a user may associate a group with a geo-location by deploying all the nodes in that group in that location. The location can be a geographical region or an availability zone for a cloud deployment or their equivalents for an on-premises deployment.
Postgres Tutorials

EDB Tutorial: How To Contain Bloat with Partitions

PGConf India 2018 attracted a large number of PostgreSQL users and developers. I talked about "query optimization techniques for partitioned tables" ( slides). Last year, I had held an introductory talk about PostgreSQL's declarative partitioning support ( slides). Many conference participants shared their perspectives on partitioning with me. One particular query got me experimenting a bit. The...
Postgres Tutorials

EDB Tutorial: How To ALTER the Bounds of a Partition

PostgreSQL 10 is full with a lot of big, new and exciting features. Declarative partitioning is one of those. It is something users have wanted for years. During PGCon 2017, it was a hot topic of discussion. People wanted to know more about the feature, and were eager to try it out. The unconference and conference session on partitioning attracted a large crowd. One of the frequently asked...