The Future of MySQL is Postgres? | Scaling Postgres 313
Рет қаралды 7,056
Күн бұрынTo get the show notes as well as get notified of new episodes, visit:
www.scalingpostgres.com/episo...
In this episode of Scaling Postgres, we discuss whether the future of MySQL is Postgres, how to use recursive CTEs, work on OrioleDB, and PG17 performance improvements.
Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: www.scalingpostgres.com/cours...
Timestamps:
00:00 - Intro
00:24 - The Future of MySQL is Postgres
03:26 - Recursive CTE's: Transforming and Analyzing Data in PostgreSQL, Part 3
04:20 - Oriole joins Supabase
07:25 - Waiting for Postgres 17: Faster B-Tree Index Scans for IN(...) lists and ANY =
10:01 - Massive DELETEs
11:48 - Auto-archiving and Data Retention Management in Postgres with pg_partman
12:23 - PGXN v2/Architecture
12:47 - 10psql Commands That Will Make Your Life Easier
13:36 - Announcing PGDSAT to satisfy CIS benchmarks for PostgreSQL
14:07 - A Deeper Look Inside PostgreSQL Visibility Check Mechanism
14:51 - PostgreSQL Internals Part3: Understanding Processes in PostgreSQL
15:08 - Outro
#postgres #postgresql
@algonix11 2 ай бұрын
Wonderful video. Every day PostgreSQL establishes itself as the Operating System for data. This possibility of attachable storage engines caught my attention. A RAM compressed storage engine would be fantastic for readonly replicas and temporary loads. But in S3 I only see it as a lab experience, as the performance would be terrible.
@foobar2662 2 ай бұрын
keep the great work
@neutralitat2570 2 ай бұрын
It’s the same like NEONdb what supabase doing 😅
@MattHudsonAtx 2 ай бұрын
The core team is unlikely to commit syntax hooks into postgres.
@m12652 2 ай бұрын
I thought sqlite was top of the list... isn't it the most installed piece of software on the planet... on pretty much every OS and device...
@Chris-rm1pn 2 ай бұрын
For Postgres to replace MySQL/MariaDB it'll first need to get equivalent to Galera and so far I haven't seen any
@chrishabgood8900 2 ай бұрын
Recursive cte, ugghhhh
Comedy Club
Рет қаралды 7 МЛН
Scaling Postgres
Рет қаралды 1 М.
Microsoft Developer
Рет қаралды 28 М.