Amit Langote
Principal Software Engineer at PostgreSQL Global Development Group
Tokyo, Japan
Summary
👤
Senior🎓
Top SchoolAmit Langote is a Principal Software Engineer based in Tokyo with 12 years of experience specializing in PostgreSQL internals, query execution, and performance engineering. A long-time community contributor and PostgreSQL committer whose work has appeared in every major release since 9.6, he authored and optimized features such as table partitioning and continues to focus on executor and query performance. At Microsoft he contributes to Azure Postgres upstream efforts, and previously held principal engineering roles at EDB and NTT where he combined feature development with L2 support and performance validation. His open-source contributions include stabilizing pg_repack to avoid deadlocks and implementing Oracle-compatible types and string functions in orafce, demonstrating deep attention to correctness and interoperability. Known for pragmatic, low-level database fixes that surface across point releases, he blends production-grade engineering with sustained community stewardship.
12 years of coding experience
11 years of employment as a software developer
Bachelor of Engineering, Computer Science and Engineering, Bachelor of Engineering, Computer Science and Engineering at MIT College of Engineering, Pune
Github Skills (16)
c1710
locking10
databases10
webextension10
locks10
oracle10
postgresql10
oracles10
c1110
sql10
database-design10
database10
distributed-database9
distributed-systems9
cpp8
Programming languages (10)
Github contributions (5)
orafce/orafce
Dec 2014 - Feb 2015
The "orafce" project implements in Postgres some of the functions from the Oracle database that are missing (or behaving differently).Those functions were verified on Oracle 10g, and the module is useful for production work.
Role in this project:
Back-end Developer / Database Engineer
Back-end Developer / Database EngineerContributions:19 commits, 6 PRs, 4 comments in 2 months
Contributions summary:Amit contributed significantly to the `orafce` project by implementing Oracle database functionalities within PostgreSQL. Their work involved defining and implementing new data types like `VARCHAR2` and `NVARCHAR2`, including necessary functions for input, output, and casting. Furthermore, the user added string manipulation functions such as `substrb`, `strposb`, and `lengthb`. The user also addressed inconsistencies by creating new versions of Oracle-compatible `LPAD`, `RPAD`, `LTRIM`, `RTRIM`, `BTRIM`, and `LENGTH` functions.
oracleoracle-10goracle-databaseorafcepostgresql
reorg/pg_repack
May 2015 - Feb 2016
Reorganize tables in PostgreSQL databases with minimal locks
Role in this project:Database Engineer / Database Administrator
Database Engineer / Database AdministratorContributions:7 commits, 5 PRs, 22 comments in 9 months
Contributions summary:Amit primarily contributed to improving the robustness and stability of the pg_repack utility, focusing on preventing deadlocks during table reorganization. They addressed potential deadlock scenarios within the `repack_drop` function by implementing exclusive table locks. Further contributions involved expanding comments to clarify the locking mechanisms and updating the code to handle schema names in lock statements. The user also added release notes for recent versions, detailing fixes and enhancements.
postgresql-database
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.