Solving PostgreSQL wicked problems
Alexander Korotkov is a PostgreSQL Major Contributor & Committer, and PhD in computer science. He contributed many fields of PostgreSQL including indexing, statistics, concurrency, extensibility, and more. In 2015 Alexander co-founded and became the technical chief and development officer at Postgres Professional in Moscow. He is the inventor behind OrioleDB who seeks to deliver the solutions of PostgreSQL wicked problems.
No video of the event yet, sorry!
It's more than 25 years since PostgreSQL was developed by the Open Source community. Through this time, we can track how the PostgreSQL community did a brilliant job adding new features and improving existing things, making PostgreSQL one of the most popular DBMSes in the world.
At the same time, we can see a set of wicked problems in PostgreSQL design, which came from Berkley or were added on very early development stages. Those problems are very annoying for users (especially for Enterprises) and aren't resolved for decades: bloat, xid wraparound, write-amplification, and more. Therefore, although PostgreSQL looks stronger than ever, it has a hidden weakness of the vast internal technical debt. To continue the successful way of PostgreSQL in the global market, we have to deal with this debt.
Thankfully, the key feature of PostgreSQL is extensibility, which was an essential part of the initial Postgres design. Extensibility scales the development: it lets multiple teams work independently on improving different aspects of PostgreSQL. And it became much more robust with table access methods API in PostgreSQL 12.
Miraculously, with just a small patch to PostgreSQL core extending this API, it appears possible to solve wicked PostgreSQL problems in a new engine made within an extension. This talk covers how the new engine is integrated with PostgreSQL Core and solves the wicked PostgreSQL problems.
- 2022 April 8 09:00 PDT
- 50 min
- Santa Clara
- Silicon Valley 2022