Pavan Deolasee
Esteemed Senior Principal Engineer at EDB
Pune, Maharashtra, India
Summary
🤩
Rockstar🎓
Top SchoolPavan Deolasee is an esteemed Senior Principal Engineer with over two decades of experience specializing in database internals, clustering and distributed systems, and system-level C programming on Linux/Unix. He has driven core features in PostgreSQL—most notably contributing HOT (Heap Only Tuples)—and was a core architect of Postgres-XC, authoring the Global Transaction Manager for scalable distributed SQL. At EDB and 2ndQuadrant he has delivered production-grade replication and multi-master features and recently enhanced the widely used pglogical extension with a high-throughput multi-insert API using a binary COPY pipe. Comfortable in both large enterprise and startup environments, he blends deep theory with hands-on engineering across open-source, community-driven projects and commercial products. Based in Pune, India, he combines an IIT Bombay MTech pedigree with a pragmatic focus on performance and interoperability that repeatedly surfaces in cross-version and cross-cluster compatibility fixes. Colleagues rely on him for solving thorny consistency, recovery, and planner/executor challenges that others shy away from.
16 years of coding experience
11 years of employment as a software developer
Indian Institute of Technology BombayBE, Computer Science, BE, Computer Science at Visvesvaraya National Institute of Technology
English
Stackoverflow
84reputation
10kreached
3answers
1question
Github Skills (18)
postgresql10
admin10
databases10
database-administration10
c1110
c1710
database-replication10
database10
apidoc9
api9
data-transformation9
iframe6
database-cluster6
citus6
drop-database6
Programming languages (3)
Github contributions (5)
2ndQuadrant/pglogical
Feb 2017 - Jul 2022
Logical Replication extension for PostgreSQL 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.
Role in this project:
Backend Developer
Backend DeveloperContributions:1 review, 12 commits, 2 PRs in 5 years 5 months
Contributions summary:Pavan primarily focused on enhancing the `pglogical` extension's functionality, specifically concerning multi-insert operations. They added a new API for handling multi-inserts within the apply worker and implemented this API using a binary COPY mechanism through pipes, which involves modifying `pglogical_apply_spi.c`. The user also addressed compatibility issues with Postgres-XL, refactoring the code to accommodate its specific requirements. Further improvements included correct quoting of identifiers in generated SQL queries.
subscriptionetlpostgrespostgresqlupgrades
arcivanov/postgres-xl
Jul 2014 - Mar 2015
Contributions:136 commits in 7 months
controlledfixesgithub-clonepostgrespostgresql
Find and Hire Top DevelopersWe’ve analyzed the programming source code of over 60 million software developers on GitHub and scored them by 50,000 skills. Sign-up on Prog,AI to search for software developers.