正在加载视频...

视频加载失败

加载此视频时出现问题。这可能是由于临时网络问题，或视频可能不可用。

🐘 Introducing Postgres Internals in 3D. 🌟 Stop reading boring diagrams. Start exploring PostgreSQL. An interactive 3D map to understand how Postgres actually works. 100% free. Built for developers.

alex shapalov

3,751 subscribers

46,606 次观看 • 12 天前 •via X (Twitter)

教育科学技术

Anya Rossi• Live Now

Private livecam show

19 条评论

Remotely 的头像

Remotely12 天前

wow! 3d!

alex shapalov 的头像

alex shapalov12 天前

pi in 3d

ActiveRabbit 的头像

ActiveRabbit12 天前

Finally, Postgres internals you can actually see. 🐘

pgrun.dev 的头像

pgrun.dev12 天前

Start with Disk → Memory → WAL.

alex shapalov 的头像

alex shapalov12 天前

Good road map!

alex shapalov 的头像

alex shapalov12 天前

I just spent an hour exploring this 3D map of PostgreSQL internals. Surprisingly addictive and inspiring! Now you’ll finally understand what the Postmaster actually does. 🐘

Gorka Cesium 的头像

Gorka Cesium12 天前

I bet @convex is already working on something similar

alex shapalov 的头像

alex shapalov12 天前

@convex show me the link

Brinkin 的头像

Brinkin12 天前

this feels like the future of realtime telemetry

alex shapalov 的头像

alex shapalov12 天前

Exactly! Telemetry should be something you explore, not just dashboards you stare at)

al 的头像

al12 天前

ooooooo Im going to use this...

alex shapalov 的头像

alex shapalov12 天前

sure! let's learn PG!

matthew 的头像

matthew12 天前

This is how is present architecture and system design now. UML and ADR are dead.

alex shapalov 的头像

alex shapalov12 天前

This is how I present architecture and system design now.

Sujal 的头像

Sujal11 天前

Can you click into a single query and watch it go through the planner?

alex shapalov 的头像

alex shapalov11 天前

Click on INSERT

Sujal 的头像

Sujal11 天前

ha, trying the INSERT one tonight

Brjan | AI Builder 的头像

Brjan | AI Builder12 天前

interactive 3D maps could make complex concepts way more digestible for devs

alex shapalov 的头像

alex shapalov11 天前

Yes, 🙌

相关视频

Finish the week with a Postgres video 🌟 All about using JSON in Postgres: - when you should use it - how to use it efficiently - how JSONs actually get stored in postgres.

Finish the week with a Postgres video 🌟 All about using JSON in Postgres: - when you should use it - how to use it efficiently - how JSONs actually get stored in postgres.

Gwen (Chen) Shapira

27,636 次观看 • 1 年前

🚀 launched today: 🐘 Postgres branches for every AI agent. → build a Postgres branch in ~3 seconds → production-like data → isolated database for every agent → sensitive data automatically masked → branch → work → delete Already ~100 Postgres branches/week before public launch. Now we're building the Postgres runtime for agents.

🚀 launched today: 🐘 Postgres branches for every AI agent. → build a Postgres branch in ~3 seconds → production-like data → isolated database for every agent → sensitive data automatically masked → branch → work → delete Already ~100 Postgres branches/week before public launch. Now we're building the Postgres runtime for agents.

alex shapalov

113,130 次观看 • 1 个月前

Introducing the latest in Postgres for agentic workloads. Agents can now branch or wake your Postgres database instantly.

Introducing the latest in Postgres for agentic workloads. Agents can now branch or wake your Postgres database instantly.

Xata 🦋

355,744 次观看 • 4 个月前

Introducing pg_strict for Postgres. Our new extension adds a safety net to Postgres, catching dangerous queries before they run.

Introducing pg_strict for Postgres. Our new extension adds a safety net to Postgres, catching dangerous queries before they run.

PlanetScale

114,704 次观看 • 9 个月前

How Postgres 17 improves IN queries In prior releases, postgres would loop and do multiple "primitive" index scans as many as your IN elements. In Postgres 17 it takes an array and eliminates the need for multiple scans. This only applies for constant values

How Postgres 17 improves IN queries In prior releases, postgres would loop and do multiple "primitive" index scans as many as your IN elements. In Postgres 17 it takes an array and eliminates the need for multiple scans. This only applies for constant values

Hussein Nasser

143,703 次观看 • 1 年前

Introducing dba: The Autonomous AI Agent for Postgres

Introducing dba: The Autonomous AI Agent for Postgres

Tembo

26,636 次观看 • 1 年前

Introducing Supabase Compute, in private alpha. You don’t need a second platform for your agents and long-running jobs. Run them in your Supabase project, next to your data in Postgres. See how it works →

Introducing Supabase Compute, in private alpha. You don’t need a second platform for your agents and long-running jobs. Run them in your Supabase project, next to your data in Postgres. See how it works →

Supabase

49,163 次观看 • 13 小时前

Seems like an interactive 2D & 3D museum is being built for Juice WRLD's upcoming album "The Outsiders" 👀 "2D/3D interactive virtual world building similar to the Legends Never Die digital museum..." We actually getting the album 🔥

Seems like an interactive 2D & 3D museum is being built for Juice WRLD's upcoming album "The Outsiders" 👀 "2D/3D interactive virtual world building similar to the Legends Never Die digital museum..." We actually getting the album 🔥

RileyTaugor 🏴

22,525 次观看 • 3 个月前

Textbooks haven't changed in 100 years. Until now... Smart Biology's LIFE 3D Animated Textbooks replace flat diagrams with immersive 3D models, narration, and interactive quizzes. It's the textbook reimagined. #biology #science #3D #animations #EdTech

Textbooks haven't changed in 100 years. Until now... Smart Biology's LIFE 3D Animated Textbooks replace flat diagrams with immersive 3D models, narration, and interactive quizzes. It's the textbook reimagined. #biology #science #3D #animations #EdTech

Smart Biology

70,821 次观看 • 1 年前

Computer can create interactive 3D diagrams to help you visualize things like furniture assembly.

Computer can create interactive 3D diagrams to help you visualize things like furniture assembly.

Computer

48,966 次观看 • 27 天前

Built an interactive 3D microbial visualisation web app exploring bacteria structures through procedural organic shaders, detailed organism simulations and microscopy-inspired visuals.

Built an interactive 3D microbial visualisation web app exploring bacteria structures through procedural organic shaders, detailed organism simulations and microscopy-inspired visuals.

Techartist

20,282 次观看 • 5 个月前

Your Postgres is 100x slower than traditional OLAP engines. A deceptively simple OSS extension fixes this. Here's an interview where we dive into the deep engineering around how this is achieved. Joining me (and leading the conversation) is Marco Slot: an engineer with an EXTENSIVE and impressive career history around PostgreSQL: 👉 Created pg_cron in 2017 (3.7k stars) - a tool to run cron-jobs in Postgres 👉 Built pg_incremental - fast, reliable, incremental batch processing inside PostgreSQL itself 👉 co-created pg_lake (after working on Crunchy Data's Warehouse, and getting acquired into Snowflake) 👉 Helped get pg_documentdb (MongoDB-on-Postgres) off the ground Marco Slot is a world-class expert in Postgres extensions. He seriously impressed me with his knowledge over the course of a private LinkedIn conversation, and now that I type out his resume - I understand where it came from. He should be on everyone's radar. So I brought him on the pod. In our full 2-hour deep-dive, we went over: • 🔥 how pg_lake makes analytics 100x faster (literally) • 🔥 perf internals like vectorized execution & CPU branching • 🤔 practical differences between OLTP and OLAP database development (and the age-old mission in uniting both) • 🤔 how (and why) pg_lake intercepts query plans and delegates parts of the query tree to DuckDB • 💡 why Postgres is architecturally terrible at analytical queries (and how vectorized execution fixes this) • 💡 Marco's hard-won experience through a decade+ career in Postgres • 🏆 Iceberg's role as the TCP/IP for tables • 🏆 what the real moat of PostgreSQL is Developments like pg_lake are a real reason why "Just Use Postgres" is much more than a meme, and it'll continue to dominate discourse. I promise you will learn a lot from this episode. Timestamps: (0:02) What is pg_lake? (2:23) Postgres' 100x slower problem and columnar storage experiments they had to make Postgres fast for analytics (6:00) practical examples and internals (16:20) perf internals - vectorized execution & CPU optimization (23:00) pg_lake architecture (why DuckDB isn't embedded) and the connection-per-process issue (29:16) how pg_lake intercepts the query plan tree and delegates parts to DuckDB (41:09) Iceberg catalogs (48:24) postgres to iceberg ingestion patterns (and pg_incremental) (53:40) Marco's (long) career: early AWS, Citus, Microsoft, Crunchy Data & Snowflake (1:04:20) Marco's observations around the merging between OLTP and OLAP (and the subtle dev differences there) (1:15:30) reverse ETL (1:33:08) Iceberg as the TCP/IP for tables (1:35:00) Marco's thoughts on the "Just Use Postgres" fever

Your Postgres is 100x slower than traditional OLAP engines. A deceptively simple OSS extension fixes this. Here's an interview where we dive into the deep engineering around how this is achieved. Joining me (and leading the conversation) is Marco Slot: an engineer with an EXTENSIVE and impressive career history around PostgreSQL: 👉 Created pg_cron in 2017 (3.7k stars) - a tool to run cron-jobs in Postgres 👉 Built pg_incremental - fast, reliable, incremental batch processing inside PostgreSQL itself 👉 co-created pg_lake (after working on Crunchy Data's Warehouse, and getting acquired into Snowflake) 👉 Helped get pg_documentdb (MongoDB-on-Postgres) off the ground Marco Slot is a world-class expert in Postgres extensions. He seriously impressed me with his knowledge over the course of a private LinkedIn conversation, and now that I type out his resume - I understand where it came from. He should be on everyone's radar. So I brought him on the pod. In our full 2-hour deep-dive, we went over: • 🔥 how pg_lake makes analytics 100x faster (literally) • 🔥 perf internals like vectorized execution & CPU branching • 🤔 practical differences between OLTP and OLAP database development (and the age-old mission in uniting both) • 🤔 how (and why) pg_lake intercepts query plans and delegates parts of the query tree to DuckDB • 💡 why Postgres is architecturally terrible at analytical queries (and how vectorized execution fixes this) • 💡 Marco's hard-won experience through a decade+ career in Postgres • 🏆 Iceberg's role as the TCP/IP for tables • 🏆 what the real moat of PostgreSQL is Developments like pg_lake are a real reason why "Just Use Postgres" is much more than a meme, and it'll continue to dominate discourse. I promise you will learn a lot from this episode. Timestamps: (0:02) What is pg_lake? (2:23) Postgres' 100x slower problem and columnar storage experiments they had to make Postgres fast for analytics (6:00) practical examples and internals (16:20) perf internals - vectorized execution & CPU optimization (23:00) pg_lake architecture (why DuckDB isn't embedded) and the connection-per-process issue (29:16) how pg_lake intercepts the query plan tree and delegates parts to DuckDB (41:09) Iceberg catalogs (48:24) postgres to iceberg ingestion patterns (and pg_incremental) (53:40) Marco's (long) career: early AWS, Citus, Microsoft, Crunchy Data & Snowflake (1:04:20) Marco's observations around the merging between OLTP and OLAP (and the subtle dev differences there) (1:15:30) reverse ETL (1:33:08) Iceberg as the TCP/IP for tables (1:35:00) Marco's thoughts on the "Just Use Postgres" fever

Stanislav Kozlovski

16,910 次观看 • 6 个月前

`bunx pg-here` global one-liner to run a standalone postgres instance with all data within the current folder throw-away postgres anytime anywhere. cli args for version/user/pass/db configs. docs: stop using docker just to launch a postgres!!

`bunx pg-here` global one-liner to run a standalone postgres instance with all data within the current folder throw-away postgres anytime anywhere. cli args for version/user/pass/db configs. docs: stop using docker just to launch a postgres!!

murat 🍥

50,537 次观看 • 8 个月前

Go beyond the docs. Agglayer just got visual. Introducing the Agglayer Visualizer: a 3D interactive tool for exploring how unified bridging and crosschain settlement actually work under the hood. If you’re a visual learner, you’ll want to check this out ⬇️

Go beyond the docs. Agglayer just got visual. Introducing the Agglayer Visualizer: a 3D interactive tool for exploring how unified bridging and crosschain settlement actually work under the hood. If you’re a visual learner, you’ll want to check this out ⬇️

Agglayer

63,739 次观看 • 1 年前

Scale PostgreSQL reads the easy way. In #AzureFriday, Scott Hanselman 🌮 and Paula Berenguel show how PostgreSQL on Azure uses read replicas and virtual endpoints to handle heavy read workloads, just like OpenAI powers ChatGPT on Postgres. Watch now:

Scale PostgreSQL reads the easy way. In #AzureFriday, Scott Hanselman 🌮 and Paula Berenguel show how PostgreSQL on Azure uses read replicas and virtual endpoints to handle heavy read workloads, just like OpenAI powers ChatGPT on Postgres. Watch now:

Microsoft Azure

31,180 次观看 • 2 个月前

Replit Agent (launched today) built a startup landing page with waitlist and postgres db from start to finish in <4 mins

Replit Agent (launched today) built a startup landing page with waitlist and postgres db from start to finish in <4 mins

aman

237,308 次观看 • 2 年前

Napkin sketch to interactive 3D rendering! Antigravity is the agentic development platform for developers to turn hand-drawn sketches into fully functional 3D learning modules.

Napkin sketch to interactive 3D rendering! Antigravity is the agentic development platform for developers to turn hand-drawn sketches into fully functional 3D learning modules.

Google Antigravity

67,113 次观看 • 4 个月前

I built a post-run recap design studio in SwiftUI Live animated map, 2D and 3D rendering, full customization. Here's how everything works 👇

I built a post-run recap design studio in SwiftUI Live animated map, 2D and 3D rendering, full customization. Here's how everything works 👇

JC Builds

37,931 次观看 • 4 个月前

This is how gravity actually works in reality in the 3D universe.

This is how gravity actually works in reality in the 3D universe.

Science Simplified

19,675 次观看 • 4 个月前

it can actually. video calls with Postgres

it can actually. video calls with Postgres

Nick Van Wiggeren

134,401 次观看 • 8 个月前