Postgres is a widely used open-source database for OLTP, and its powerful SQL features are continually improving. However, it faces operational challenges such as process per connection, vacuum issues, resilience to failure, and downtime for upgrades. These issues require a different storage architecture. Distributed SQL, inspired by Spanner, addresses some of these issues but often has limited SQL support. It is also essential to remain Open Source when offering an alternative to PostgreSQL

YugabyteDB overcomes these limitations by utilizing PostgreSQL code for SQL processing on multiple active nodes and employing distributed transactional storage to scale horizontally. This marks the evolution of databases towards Distributed SQL databases. We will demonstrate YugabyteDB's resilience and scalability.

This session brings the concepts of Distributed SQL and a live demo showing PostgreSQL compatibility, elasticity, and resilience