Postgres FM

@PostgresFM

A weekly podcast about all things PostgreSQL — by @michristofides and @samokhvalov. Also at http://fosstodon.org/@postgresfm

🎧 Podcast + 📺 YouTube

postgres.fm

Joined July 2022

214Posts 2KFollowers 3Following

You might like

@crunchydata

@samokhvalov

@postgresql_007

@PavloGolub

@tobias_petry

@rxin

@kiwicopple

@mattklein123

@dataegret

@josepheconway

@cyberdemn

@praetorianlabs

@pgMustard

@CockroachDB

@juansequeda

Postgres FM

Oct 3

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

PostgresFM's tweet image. 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

Postgres FM

Sep 26

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

PostgresFM's tweet image. 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

Postgres FM

Sep 19

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

PostgresFM's tweet image. 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

Postgres FM

Sep 12

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

PostgresFM's tweet image. 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

Postgres FM

Sep 5

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

PostgresFM's tweet image. 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

Postgres FM

Aug 29

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

PostgresFM's tweet image. 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

Postgres FM

Aug 22

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

PostgresFM's tweet image. 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

Postgres FM

Aug 15

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

PostgresFM's tweet image. 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

Postgres FM

Aug 8

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

PostgresFM's tweet image. 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

Postgres FM

Jul 25

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…

PostgresFM's tweet image. 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…

Postgres FM

Jul 18

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

PostgresFM's tweet image. 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

Postgres FM

Jul 11

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

PostgresFM's tweet image. 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

Postgres FM

Jun 20

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

PostgresFM's tweet image. 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

Postgres FM

Jun 13

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

PostgresFM's tweet image. 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

Postgres FM

Jun 6

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

PostgresFM's tweet image. 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

Postgres FM

May 30

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

PostgresFM's tweet image. 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

Postgres FM

May 23

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

PostgresFM's tweet image. 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

Postgres FM

May 9

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

PostgresFM's tweet image. 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

Postgres FM

May 2

New episode: "synchronous_commit" Nikolay and Michael discuss synchronous_commit — what it means on single node setups, for synchronous replication setups, and the pros and cons of the different options for each. 🎧 postgres.fm/episodes/synch… 📺 youtu.be/wKBGjbdrEvQ

PostgresFM's tweet image. New episode: "synchronous_commit"

Nikolay and Michael discuss synchronous_commit — what it means on single node setups, for synchronous replication setups, and the pros and cons of the different options for each.

🎧 postgres.fm/episodes/synch…

📺 youtu.be/wKBGjbdrEvQ

Postgres FM

Apr 25

New episode: "Managed service support" Nikolay and Michael discuss managed service support — tips for cases that aren't going well, requesting features, factoring in support when choosing, and whether to use one at all. 🎧 postgres.fm/episodes/manag… 📺 youtu.be/xpTNaih5pwo

PostgresFM's tweet image. New episode: "Managed service support"

Nikolay and Michael discuss managed service support — tips for cases that aren't going well, requesting features, factoring in support when choosing, and whether to use one at all.

🎧 postgres.fm/episodes/manag…

📺 youtu.be/xpTNaih5pwo

Nik Samokhvalov

@samokhvalov

Ryan Booz

@ryanbooz

Maciej Walkowiak 🍃

@maciejwalkowiak

Hussein Nasser

@hnasr

Denis Magda

@denismagda

Michael Christofides 💙💛

@michristofides

CYBERTEC PostgreSQL Services and Support

@PostgresSupport

Jessica Eliason (Sharp)

@jeliDBA

Principe do Oceano

@rponte

think(x)

@thinkx

Bertrand Drouvot

@BertrandDrouvot

RustProof Labs 🐘

@RustProofLabs

Josh Long

@starbuxman

Juan Manuel

@babui_

ΛNGΞL

@marthaelax

sreedhar

@puppalas

Özkan Pakdil

@thejvmbender

Shreyas Kaundinya

@shreyassk08

 Id: { ALIAS111 }

@Alias_One11

John Theisen

@JTheisen

योगीनाथ आदित्य

@SanghiYogi

paneer sabji

@paneer_sabji

faizan zia

@faizanzia1

focus

@focuser_pro

Phakorn Kiong

@PhakornKiong

Jeanne Lane

@jmlane8

Deepak Panmand

@deepak111101

toastie456

@toastie456

ZC

@ZC41255

Harry Brundage

@harrybrundage

Michael Rayva

@mrayva

tabi yoku

@tubiyoku

Kazi Ershed Ahmed

@ErshedAhmed1965

Shon

@shonsatianov

Muhamad Iqbal

@Mhmmdiqbalee

RishikeshK

@Rishike89765470

Alexandre Araujo

@ale_araujo16

Akshada Shinde

@AkshadaShinde17

Aman

@Aman1239950

Jukka Pihl

@jukkapihl

NIYONKURU VALENS

@NIYONKURUVALE15

endetti

@endetti

Rajat Gupta

@rajatpace

kenalt

@alttech_23f

Garry C Marshall

@GazCMarsh

Eric Kelly

@HeroicEric

Sarthak Bhol

@Sarthak_B08

Anurag

@MisguidedEip

Parth Desai

@psdesai_93

Bbbbbbb

@jamalloollloo

phuc phung

@phucphungttt

Vasista Bhargav

@bhargav_vasista

Akash Manohar

@HashNuke

Mazinho Web

@mazinhoweb

Sachin Pawar

@sach_pwr

Ben Dicken

@BenjDicken

Everly Smith

@EverlySmit47791

Tony Dang

@thisistonydang

centrix

@centrixsystems

Pantelis Nasikas

@pnasikas

$wormphlegm's profile picture. What are we, cats in an alley? Flipping bits \u{40}\u{f8ff}$

chicio

@wormphlegm

Jasper 張 🟠

@jasper_teo

Reymar Sanchez

@SanchezReymar

Nik Samokhvalov

@samokhvalov

Michael Christofides 💙💛

@michristofides

PostgreSQL

@PostgreSQL

United States Trends

1. D’Angelo 268K posts
2. Brown Sugar 19.9K posts
3. #PortfolioDay 14.8K posts
4. Young Republicans 11.3K posts
5. Pentagon 107K posts
6. Drew Struzan 25.9K posts
7. Politico 158K posts
8. Black Messiah 10.2K posts
9. Big 12 13.2K posts
10. Scream 3 N/A
11. Voodoo 20.5K posts
12. Jeff Albert N/A
13. Venables 3,409 posts
14. Soybeans 4,472 posts
15. Merino 11.9K posts
16. VPNs 1,369 posts
17. Baldwin 20.2K posts
18. Happy Birthday Charlie 143K posts
19. How Does It Feel 8,927 posts
20. World Cup 319K posts

You might like

Something went wrong.

Something went wrong.