PostgresFM Profile Banner
Postgres FM Profile
Postgres FM

@PostgresFM

Followers
2K
Following
98
Media
171
Statuses
219

A weekly podcast about all things PostgreSQL — by @michristofides and @samokhvalov. Also at https://t.co/lQaOt18aZ0

🎧 Podcast + 📺 YouTube
Joined July 2022
Don't wanna be here? Send us removal request.
@PostgresFM
Postgres FM
10 days
New episode: "max_connections vs migrations" Nik and Michael discuss max_connections, especially in the context of increasing it to solve problems like migrations intermittently failing(!) 🎧 https://t.co/3sN6YY1b9J 📺 https://t.co/8LOhzd7YyO
0
1
7
@PostgresFM
Postgres FM
24 days
New episode: "What's new in EXPLAIN" Nik and Michael discuss the various changes to EXPLAIN that arrived in Postgres 18. 🎧 https://t.co/bNpmOUChDZ 📷 https://t.co/QT1I1YW2Zd
0
1
4
@PostgresFM
Postgres FM
1 month
New episode: "Tens of TB per hour" Nik talks Michael through a recent benchmark he worked with Maxim Boguk on, to see how quickly they could provision a replica. 🎧 https://t.co/NTbL4wMCJn 📺 https://t.co/nMIOwkcUDL
0
4
15
@PostgresFM
Postgres FM
1 month
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. 🎧 https://t.co/a3vxL6YWNU 📺 https://t.co/XVGyrnjQTI
1
3
5
@PostgresFM
Postgres FM
2 months
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. 🎧 https://t.co/AqEXZWKyER 📺 https://t.co/hverE778te
0
1
3
@PostgresFM
Postgres FM
2 months
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. 🎧 https://t.co/XGZwwRj7N3 📺 https://t.co/IZHziznUgq
0
1
9
@PostgresFM
Postgres FM
3 months
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. 🎧 https://t.co/gwWj1wAQr9 📺 https://t.co/hUZLd01T5O
0
1
5
@PostgresFM
Postgres FM
3 months
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! 🎧 https://t.co/ts2mEyL4O7 📺 https://t.co/z6h2wSyYq0
0
3
14
@PostgresFM
Postgres FM
3 months
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. 🎧 https://t.co/rnW023GHv0 📺 https://t.co/eBgvKyjYkp
0
2
5
@PostgresFM
Postgres FM
3 months
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. 🎧 https://t.co/2bisgMv0jV 📺 https://t.co/B10N75e6IW
2
2
24
@PostgresFM
Postgres FM
4 months
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. 🎧 https://t.co/zrUM2hUMEG 📺 https://t.co/fQVwxrvY20
1
6
14
@PostgresFM
Postgres FM
4 months
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. 🎧 https://t.co/JJ2U7Grb3U 📺 https://t.co/mNKUUu9t3K
0
2
12
@PostgresFM
Postgres FM
4 months
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. 🎧 https://t.co/xKkxTc38m6 📺 https://t.co/TyaUDPupY9
0
1
8
@PostgresFM
Postgres FM
4 months
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. 🎧 https://t.co/tcuCWPLWGq 📺 https://t.co/aae974VCfO
0
1
6
@PostgresFM
Postgres FM
5 months
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. 🎧 https://t.co/A685sBU1uV 📺 https://t.co/qnlo3vFCXV
0
4
10
@PostgresFM
Postgres FM
5 months
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! 🎧 https://t.co/27fRrOMEOR 📺 https://t.co/570QRFSv3X
0
3
11
@PostgresFM
Postgres FM
5 months
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! 🎧 https://t.co/nWfNWd7d73 📺 https://t.co/gGjfIUEElB
2
16
71
@PostgresFM
Postgres FM
6 months
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. 🎧 https://t.co/nIkFpr4jbf 📺 https://t.co/wo85nCUlaQ
0
5
36
@PostgresFM
Postgres FM
6 months
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. 🎧 https://t.co/qKZJoDLQnC 📺 https://t.co/7CtOZXH9tL
0
2
12
@PostgresFM
Postgres FM
6 months
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. 🎧 https://t.co/cELugdLXOA 📺 https://t.co/S62qt1UbcJ
0
2
24