Features for Scalable PostgreSQL in Cloud Spanner
No video of the event yet, sorry!
Cloud Spanner launched a PostgreSQL interface in 2022 with the goals of improving developer familiarity and application portability. A primary objective of our implementation was to provide Spanner's full scalability and fault tolerance capabilities. This proved challenging because Spanner's architecture is purpose-built for hyper scale, geo-distributed data and clients, and fully managed cloud hosting. To address this, we extended Spanner's PostgreSQL dialect to better execute workloads in this environment. For example, Spanner provides DDL syntax to support declarative parent-child table relationships to allow write clustering. We added new session parameters to indicate acceptable read staleness to reduce round-trip latency and implemented a wire proxy to make sessions resilient to TCP connection breaks. In this presentation, I will talk about what we added, how you can use these features to improve performance and reliability, and how we can live up to our portability goals with these extensions.
- 2023 April 21 15:50 PDT
- 20 min
- Santa Clara, Lvl C
- Silicon Valley 2023