Scaling Postgres Celebration | Scaling Postgres 300
Рет қаралды 503
Күн бұрын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 look back over 300 episodes, discuss a way to find locking processes, review disadvantages of cloud hosted solutions, and how to partition with UUIDv7.
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
03:39 - One PID to Lock Them All: Finding the Source of the Lock in Postgres
07:04 - Why Postgres RDS didn’t work for us (and why it won’t work for you if you’re implementing a big data solution)
09:50 - How to partition Postgres tables by timestamp based UUIDs
10:07 - Partitioning Postgres tables by timestamp based UUIDs
11:45 - PGXN creator David Wheeler joins Tembo to strengthen PostgreSQL extension ecosystem
12:54 - I’m a Postgres Extensions Tembonaut
13:05 - pgvector
14:06 - Extensions for PostgreSQL, how we participate at Adjust?
15:03 - PostgreSQL 17: copy and SAVE_ERROR_TO
16:02 - PostgreSQL is now a CVE Numbering Authority (CNA)
16:17 - PostgreSQL parallel query problems in JDBC and DBeaver
17:14 - POSETTE: An Event for Postgres 2024
17:33 - Outro
#postgres #postgresql
@jaegeunyu4449 5 ай бұрын
I really appreciate Scaling PostgreSQL. I have been watching this series for the last three or four years. At last I have clicked on the subscription button today. I am a lazy person. This is my first KZfaq channel I have ever subsribed to in my life.
@ScalingPostgres 5 ай бұрын
Thanks! Wow, it is quite an honor to be your first subscription!
@nandocamila 5 ай бұрын
Congrats and thank you for the time you dedicate to surface postgres' news and materials
@ScalingPostgres 5 ай бұрын
Thanks!
@vinny142 5 ай бұрын
Congratulations! You are still a great source of updates and inspiration!
@ScalingPostgres 5 ай бұрын
Thank you so much!
@jaimeduncan6167 5 ай бұрын
Congratulation for episode 300. Thanks for all the good work. This videos take a lot of time and research, we appreciate them.
@ScalingPostgres 5 ай бұрын
Thank you very much!
@smyrnian_ 5 ай бұрын
Congratulations and thank you for your hard work! Course looks great. I can't wait.
@ScalingPostgres 5 ай бұрын
Thank you!
@jocketf3083 5 ай бұрын
Congratulations, and thank you!
@ScalingPostgres 5 ай бұрын
Thank you!
@dongwooklee4733 5 ай бұрын
Congratulation!!
@ScalingPostgres 5 ай бұрын
Thank you!!
@geojaya 5 ай бұрын
congratulations
@ScalingPostgres 5 ай бұрын
Thanks!
@professortrog7742 5 ай бұрын
Though UUID V7 is definitely an improvement over the versions that don’t have a date component in them i very much prefer the solution i rolled up 2 years ago, which is basically adding a date part on the left side of a bigint serial. See the blog section of database dot one for the code. (links not permitted in KZfaq comments)
@ScalingPostgres 5 ай бұрын
Yeah, I have thought about doing that. But, I figure the standard should be here shortly.
@rosendo3219 5 ай бұрын
congrats on episode 300. if you have russian speaking friends do not say what number this last episode is to them :)
Scaling Postgres
Рет қаралды 773
KiKiDo
Рет қаралды 3,8 МЛН
Argilla
Рет қаралды 413
Microsoft Developer
Рет қаралды 28 М.
Scaling Postgres
Рет қаралды 1 М.