Checkout the slides

YDB is a strongly consistent distributed database for mission-critical workloads with more than a decade of history that has been published to open-source in 2022. It was built from scratch with its own SQL dialect, API and query execution layer. We are happy to present the Postgres compatibility mode that has been added recently in response to open-source user feedback.

A few words about YDB architecture and internals:

• Distributed storage layer
• Tablet as a building block for scale, fault-tolerance and functionality
• Maintaining consistency even if the whole datacenter goes down
• Production scale examples (petabytes of data, millions of rps, thousands of servers in production cluster)

About PostgreSQL compatibility implementation:

• Initial research
• Good point for open-source projects
• High-level implementation principles
• Testing methodology
• Performance optimizations for Postgres queries
• Scaling read and write in postgres-like workloads, with detailed examples