How Neon Postgres manages 750,000+ Databases
In this video we're going to be learning about high overview of postgres architecture and why it's considered as a "monolith". Then we'll explore the work that Neon did to separate compute from storage while keeping existing postgres functionality and the cool features that came along with it.
To see what Neon Postgres has to offer, visit https://fyi.neon.tech/1kb to learn more!
Timeline:
00:00:00 - Intro
00:00:24 - Postgres architecture
00:02:16 - Neon's architecture
00:05:33 - Storage sharding
00:07:10 - Branching strategies
00:07:45 - Testing Neon
00:08:47 - Ending
Github repo for generating mock data:
https://github.com/kikisbytes/neon-po...
Postgres Architecture Overview:
https://severalnines.com/blog/underst...
/ postgresql-process-architecture
• PostgreSQL Internal Architecture Explained - Hussein Nasser did such an amazing job describing postgres architecture.
Neon Article links:
https://neon.tech/blog/hello-world
https://neon.tech/blog/neon-ga
https://neon.tech/blog/neon-autoscali...
https://neon.tech/flow](https://neon.tech/flow
https://neon.tech/blog/architecture-d...
https://neon.tech/blog/get-page-at-lsn - storage engine
https://neon.tech/blog/how-we-scale-a... - how to scale
https://neon.tech/blog/1-year-of-auto... - one year of auto scaling
https://neon.tech/blog/move-fast-and-... - branching strategy
Stackoverflow survey:
https://survey.stackoverflow.co/2024/...
Music credit:
♪ [non copyright music] Lofi Type Beat - Saturday Morning | aesthetic lofi music / Lofiru Link : [