Postgres FM
@PostgresFM
A weekly podcast about all things PostgreSQL — by @michristofides and @samokhvalov. Also at http://fosstodon.org/@postgresfm
Вам может понравиться
New episode: "Gapless sequences" Nik and Michael discuss the concept of gapless sequences — when you might want one, why sequences in Postgres can have gaps, and an idea or two if you do want them. 🎧 postgres.fm/episodes/gaple… 📺 youtu.be/3uIXr92GRWo
New episode: "LWLocks" Nik and Michael discuss lightweight locks in Postgres — how they differ to (heavier) locks, some occasions they can be troublesome, and some resources for working out what to do if you hit issues. 🎧 postgres.fm/episodes/lwloc… 📺 youtu.be/DdQjvYHbIRU
New episode: "User management" Nik and Michael discuss user management in Postgres — how roles work, making administration easier, setting passwords, and avoiding them being logged. 🎧 postgres.fm/episodes/user-… 📺 youtu.be/KQcDZI81-kU
New episode: "Postgres 18" Nik and Michael discuss the newly released Postgres 18 — the bigger things it includes, some of their personal highlights, and some thoughts towards the future. 🎧 postgres.fm/episodes/postg… 📺 youtu.be/EIKU1seSqEY
New episode: "Gadget's use of Postgres" Nik and Michael are joined by @harrybrundage from @gadget_dev to talk about zero-downtime major version upgrades, what they use Postgres for, their dream database, and more! 🎧 postgres.fm/episodes/gadge… 📺 youtu.be/PAgQRfgk87A
New episode: "turbopuffer" Nik and Michael are joined by @Sirupsen from @turbopuffer to discuss ANN index types, tradeoffs for search workloads, and when it can make sense to move search out of Postgres. 🎧 postgres.fm/episodes/turbo… 📺 youtu.be/dgWmmbr_Fk8
New episode: "When not to use Postgres" Nik and Michael discuss when not to use Postgres — specifically use cases where it still makes sense to store data in another system. 🎧 postgres.fm/episodes/when-… 📺 youtu.be/gY3WNWNAxxw
New episode: "Disks" Nik and Michael discuss disks in relation to Postgres — why they matter, how saturation can happen, some modern nuances, and how to prepare to avoid issues. 🎧 postgres.fm/episodes/disks 📺 youtu.be/ajxMKRheORc
New episode: "Multi-column indexes" Nik and Michael discuss multi-column indexes in Postgres — what they are, how to think about them, and some guidance around using them effectively. 🎧 postgres.fm/episodes/multi… 📺 youtu.be/bhqYDvVTxP8
New episode: "Self-driving Postgres" Nikolay and Michael discuss self-driving Postgres — what it could mean, using self-driving cars as a reference, and ideas for things to build and optimize for in this area. 🎧 postgres.fm/episodes/self-… 📺 youtu.be/0NOWMd3UuJM
New episode: "caSe-inSENsiTive" Nikolay and Michael discuss case-insensitive data — when we want to treat columns as case-insensitive, and the pros and cons of using citext, a function like lower(), or a custom collation. 🎧 postgres.fm/episodes/case-… 📺 youtu.be/jHwib2zdenQ
New episode: "Monitoring from Postgres AI" Nikolay talks to Michael about Postgres AI's new monitoring tool — what it is, how its different to other tools, and some of the thinking behind it. 🎧 postgres.fm/episodes/monit… 📺 youtube.com/watch?v=c9LVai…
New episode: "MultiXact member space exhaustion" Nikolay and Michael are joined by Andrew Johnson and Nate Brennand from Metronome to discuss the root cause of a recent incident they had, as well as some mitigation advice! 🎧 postgres.fm/episodes/multi… 📺 youtu.be/9KoP0rXbGKU
New episode: "Multigres" Nikolay and Michael are joined by @ssougou to discuss Multigres — a project he's joined Supabase to lead, building an adaptation of Vitess for Postgres! 🎧 postgres.fm/episodes/multi… 📺 youtu.be/KOepJivmWTg
New episode: "Multi-tenant options" Nikolay and Michael are joined by @gwenshap to discuss multi-tenant architectures — the high level options, the pros and cons of each, and how they're trying to help with Nile. 🎧 postgres.fm/episodes/multi… 📺 youtu.be/1pb3qZyyR58
New episode: "Mean vs p99" Nik and Michael discuss looking at queries by mean time — when it makes sense, why ordering by p99 might be better, and the merits of approximating percentiles using the standard deviation. 🎧 postgres.fm/episodes/mean-… 📺 youtu.be/ASwK4zPFzzo
New episode: "What to log" Nikolay and Michael discuss logging in Postgres — mostly what to log, and why changing quite a few settings can pay off big time in the long term. 🎧 postgres.fm/episodes/what-… 📺 youtu.be/FyY_xkDr9ts
New episode: "How to move off RDS" Nikolay and Michael discuss moving off managed services — when and why you might want to, and some tips on how for very large databases. 🎧 postgres.fm/episodes/how-t… 📺 youtu.be/cI5skCTu3TQ
New episode: "Locks" Nikolay and Michael discuss heavyweight locks in Postgres — how to think about them, why you can't avoid them, and some tips for minimising issues. 🎧 postgres.fm/episodes/locks 📺 youtu.be/LuhbMSvQ5c4
New episode: "Top ten dangerous issues" Nikolay and Michael discuss ten dangerous Postgres related issues — ones that might be painful enough to get onto the CTO and even CEOs desk, and then what you can do proactively. 🎧 postgres.fm/episodes/top-t… 📺 youtu.be/cyaY8aYM3O8
United States Тренды
- 1. Vandy 7,432 posts
- 2. Julian Sayin 3,326 posts
- 3. Carnell Tate 2,010 posts
- 4. Caicedo 16.3K posts
- 5. Arch Manning 2,918 posts
- 6. Vanderbilt 6,199 posts
- 7. Donaldson 1,933 posts
- 8. Pavia 2,430 posts
- 9. Jeremiah Smith 1,741 posts
- 10. Clemson 8,162 posts
- 11. French Laundry 4,198 posts
- 12. #HookEm 2,896 posts
- 13. Christmas 129K posts
- 14. Buckeyes 3,602 posts
- 15. Joao Pedro 10.4K posts
- 16. Jim Knowles N/A
- 17. Dalot 23.3K posts
- 18. ESPN 79.2K posts
- 19. Disney 88.7K posts
- 20. #GoBucks 2,122 posts
Вам может понравиться
-
DBLab by Postgres.AI 💙💛
@Database_Lab -
Crunchy Data
@crunchydata -
Nik Samokhvalov
@samokhvalov -
Hans-Jürgen Schönig
@postgresql_007 -
Amit Kapila
@kapila_amit -
Pavlo Golub
@PavloGolub -
Tobias_Petry.sql
@tobias_petry -
Reynold Xin
@rxin -
Paul Copplestone - e/postgres
@kiwicopple -
Matt Klein
@mattklein123 -
Data Egret | PostgreSQL support
@dataegret -
Joseph Conway
@josepheconway -
CMU Database Group
@CMUDB -
Alexander Kukushkin
@cyberdemn -
Praetorian
@praetorianlabs
Something went wrong.
Something went wrong.