Serverless PostgreSQL: Challenges and Solutions for Cloud-Based Database Services

Explore the challenges and solutions of offering PostgreSQL as a serverless cloud service in this 33-minute conference talk presented by Heikki Linnakangas from Neon at All Things Open 2023. Discover how Neon's serverless PostgreSQL can automatically scale based on workload, even scaling down to zero when not in use, making it ideal for modern stateless applications. Delve into the complexities of creating a serverless illusion for a traditionally stateful database, including techniques for sub-second startup times, separating compute and storage, running PostgreSQL in a microVM within Kubernetes, and managing connections and pooling. Gain insights into bridging the gap between PostgreSQL's mature server software and the demands of serverless architecture.