New episode: "GSoC B-Tree Merge"
Nik and Michael are joined by Salma El-Sayed and Kirk Wolak to discuss their ambitious Google Summer of Code project around adding b-tree merge support to Postgres.
🎧️️ postgres.fm/episodes/gsoc-bt…
📺️️ piped.video/vspGoD9Dc7k
ALT Pictures of Salma, Kirk, Michael, and Nik mid-recording, the episode title "GSoC B-Tree Merge", against a pink background with an elephant wearing sunglasses.
ALT Pictures Sai, Nik, and Michael mid-recording, the episode title "ClickHouse Postgres", against a pink background with an elephant wearing sunglasses.
New episode: "hot_standby_feedback"
Nik and Michael discuss hot_standby_feedback — what it controls, whether and when read replicas should be changed to on, and other settings you can change to help too.
🎧 postgres.fm/episodes/hot_sta…
📺 piped.video/B0v3DAe-B7A
ALT Pictures Nik and Michael mid-recording, the episode title "hot_standby_feedback", against a pink background with an elephant wearing sunglasses.
ALT Pictures of Shaun, Nik, and Michael mid-recording, the episode title "Estimating work_mem", against a pink background with an elephant wearing sunglasses.
New episode: "pgrust"
Nik and Michael are joined by @mmalisper, co-creator of pgrust, to discuss their Postgres rewrite, including reliability problems, compatibility testing, and a new JIT-compiled query engine.
🎧 postgres.fm/episodes/pgrust
📺 piped.video/cvNlTQWZYG4
ALT Pictures of Malis, Nik, and Michael mid-recording, the episode title "pgrust", against a pink background with an elephant wearing sunglasses.
New episode: "MVCC"
Nik and Michael are joined by Radim Marek from boringSQL to discuss MVCC, including his recent article on how Postgres chose to implement it compared to other systems.
🎧️️️ postgres.fm/episodes/mvcc
📺️️️ piped.video/MHiiI0GZS3A
ALT Pictures of Radim, Nik, and Michael mid-recording, the episode title "Xata", against a pink background with an elephant wearing sunglasses.
ALT Pictures of Fabrízio, Nik, and Michael mid-recording, the episode title "pg_stat_log", against a pink background with an elephant wearing sunglasses.
New episode: "pg_flight_recorder"
Nik and Michael are joined by David Ventimiglia to discuss pg_flight_recorder, a new tool he created for monitoring a Postgres database from within.
🎧 postgres.fm/episodes/pg_flig…
📺 piped.video/UirSQIY8_M0
ALT Pictures of David, Nik, and Michael mid-recording, the episode title "pg_flight_recorder", against a pink backround with an elephant wearing sunglasses.
New episode: "PgQue"
Nik and Michael discuss Nik's new project PgQue, a descendent of Skype's PgQ, for running queue-like workloads in Postgres.
🎧 postgres.fm/episodes/pgque
📺 piped.video/bBNcR14Ts4U
ALT Pictures of Nik and Michael mid-recording, the episode title "PgQue", against a pink backround with an elephant wearing sunglasses.
New episode: "pg_wait_tracer"
Nik and Michael are joined by Dmitry Fomin to discuss his new tool pg_wait_tracer, as well as changes to core that would allow wait event tracing with lower overhead (and on managed services).
🎧 postgres.fm/episodes/pg_wait…
📺 piped.video/efY85jwfcQ8
ALT Pictures of Dmitry, Nik, and Michael mid-recording, the episode title "pg_wait_tracer", against a pink backround with an elephant wearing sunglasses.
ALT Pictures of Nik and Michael mid-recording, the episode title "Schema design checklist", against a pink backround with an elephant wearing sunglasses.
ALT Pictures of Nik and Michael mid-recording, the episode title "Long-running transactions", against a pink backround with an elephant wearing sunglasses.
New episode: "Long-running transactions"
Nik and Michael discuss long-running transactions, including when they're harmless, when they cause issues, and how to mitigate those issues.
🎧 postgres.fm/episodes/long-ru…
📺 piped.video/uSUpbUJM5Kk
ALT Pictures of Nik and Michael mid-recording, the episode title "Long-running transactions", against a pink backround with an elephant wearing sunglasses.
ALT Pictures of Paul, Regina, Nik, and Michael mid-recording, the episode title "PostGIS", against a pink backround with an elephant wearing sunglasses.
New episode: "Plan flips"
Nik and Michael discuss query plan flips in Postgres — what they are, some causes, mitigations, longer term solutions, and the recent outage at Clerk.
🎧 postgres.fm/episodes/plan-fl…
📺 piped.video/sjv_D18QwTs
ALT Pictures of Nik and Michael mid-recording, the episode title "Plan flips", against a pink backround with an elephant wearing sunglasses.