This New Postgres Feature Is Crazy Powerful
Better Stack
0:00 / 0:00
This New Postgres Feature Is Crazy Powerful
81 678 просмотров · 4 недели назад
Better Stack
199 тыс. подписчиков
81 678 просмотров · 4 недели назад
Postgres 19 is close, and it brings native graph queries to the database you already run. Writing five table joins to answer one simple question has been the price of a relational schema for decades.
Plus ON CONFLICT DO SELECT, REPACK, and the smaller wins worth knowing before you upgrade.
🔗 Relevant Links
https://www.postgresql.org/docs/19/re...
❤️ More about us
Radically better observability stack: https://betterstack.com/
Written tutorials: https://betterstack.com/community/
Example projects: https://github.com/BetterStackHQ
📱 Socials
Twitter: / betterstackhq
Instagram: / betterstackhq
TikTok: / betterstack
LinkedIn: / betterstack
📌 Chapters:
00:00 Intro
00:30 ON CONFLICT DO SELECT
01:38 Native graph queries
02:13 Demo: joins vs. graph syntax
03:32 CREATE PROPERTY GRAPH
04:48 Does this replace Neo4j?
05:10 REPACK and reclaiming disk space
06:09 Quick fire: hints, JIT, vacuum, COPY
07:11 Release timing