Teodor Sigaev

Major Contributor at Postgres Professional

Moscow, Moscow City, Russia
email-iconphone-icongithub-logolinkedin-logotwitter-logostackoverflow-logofacebook-logo
Join Prog.AI to see contacts
email-iconphone-icongithub-logolinkedin-logotwitter-logostackoverflow-logofacebook-logo
Join Prog.AI to see contacts

Summary

👤
Senior
🎓
Top School
Teodor Sigaev is a seasoned database engineer and technology leader with over two decades of deep PostgreSQL expertise, co-founding Postgres Professional and serving as its CTO while remaining a Major Contributor and Committer to the PostgreSQL project. He helped create PostgreSQL’s full-text search system and has driven work on GIST/GIN indexes, SQL/JSON NoSQL features, and novel index access methods including spatial indexing. His background spans high-scale production systems at Mail.Ru—where he architected storage, search solutions, and an Nginx rate-limiting bot detection system—to founding projects and freelance work for enterprise clients. Notably, his open-source contributions include substantive fixes and features in the official postgres repository, such as improving tsearch2 robustness and adding websearch_to_tsquery for web-like search syntax. Trained in physics at MSU, he blends rigorous analytical thinking with hands-on systems design and a long record of shipping foundational database capabilities.
code23 years of coding experience
job19 years of employment as a software developer
bookLomonosov Moscow State University
languagesEnglish, Russian
github-logo-circle

Github Skills (10)

full-text-search10
postgresql10
indexer10
indexing10
c-programming9
data-structures8
data-structure8
performance-optimization8
parser7
lexical-analysis7

Programming languages (6)

C++CMakefileLuaObjective-CRoff

Github contributions (5)

github-logo-circle
postgres/postgres

Jul 2003 - May 2018

Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see https://wiki.postgresql.org/wiki/Submitting_a_Patch
Role in this project:
userBack-end Developer & Database Engineer
Contributions:594 commits in 15 years 1 month
Contributions summary:Teodor's contributions focused on enhancing the capabilities and robustness of the PostgreSQL tsearch2 extension. They fixed parsing errors and memory management issues related to the dictionary loading and processing. Furthermore, they added functionality, such as the implementation of the websearch_to_tsquery function for handling web search-like syntax, and improved the efficiency of the similarity calculation and indexing processes for improved query performance.
postgresql
postgrespro/wildspeed

Apr 2012 - May 2016

Contributions:2 commits in 4 years 1 month
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.
Request Free Trial