logo
episode-header-image
Jun 2023
33m 38s

They Enabled Postgres Partitioning and t...

Hussein Nasser
About this episode
In a wonderful blog, Kyle explores the pains he faced managing a Postgres instance for a startup he works for and how enabling partitioning sigintfically created wait events causing the backend and subsequently NGINX to through 500 errors. We discuss this in this video/podcast https://www.kylehailey.com/post/postgres-partition-pains-lockmanager-waits 
Up next
Sep 11
Caching is a cop-out
In this episode I explore why you should take some time to examine the operation you are caching before doing so. And why caching is a cop-out 
15m 41s
Aug 23
How open ai agents "hacked" hugging face
How open ai agents "hacked" hugging face 
17m 57s
Jul 10
How a query optimization gave birth to infinite scroll
The infinite scroll in social media as we know it today is despised by all. But it always start as a bad idea. It originated as a result of UI change to relief the backend database from inefficient queries. I explore this in this episode of the backend engineering. 0:00 Intro1:00 ... Show More
21m 20s
Recommended Episodes
Dec 2022
512: Owned With a P
tail spinning
1h 56m
May 2022
From Kubernetes to PaaS - now what? (Ship It! #51)
Today we talk to Mark Ericksen about all the things that we could be doing on the new platform - this is a follow-up to episode 50. Mark specialises in Elixir, he hosts the Thinking Elixir podcast, and he also helps make Fly.io the best place to run Phoenix apps, such as chang ... Show More
58m 10s
Oct 2023
166: Speedy Database Queries with Lukas Fittl
pganalyze: - Weekly series "5mins of Postgres": - How Postgres chooses which index to use: - CMU databases courses: - Postgres community: As well as social links: - Mastodon: - Twitter/X: @pganalyze, @LukasFittl - GitHub: @pganalyze, @lfittl - LinkedIn. 
1h 12m
Apr 2022
Postgres.js (JS Party #221)
Rasmus Porsager created Postgres.js –the fastest full-featured PostgreSQL client for Node.js and Deno. Today he joins Jerod for a deep-dive on Postgres, why he created this open source library, and how you can use it to build pg-backed JavaScript applications. 
50m 6s
Jul 2024
85. Trust But Verify
A recent equipment upgrade created an erroneous incompatibility with fuel flow sensing for pilot and social media influencer Kay Hall. Hear how it unfolded in this episode. 
29 m
Apr 2023
Surviving SVB's Collapse & Outsmarting Uber | Kyte's Nick Cobb
<p>It hasn&apos;t been smooth sailing for startups this year. As this week&apos;s guest Nick Cobb puts it &quot;You can add bank runs to the list of things founders have to deal with.&quot; Of course, it hasn&apos;t been easy going for engineering leaders either. <br/><br/>That&a ... Show More
46m 11s
Aug 2020
#94 The Breaking Point
When gyms closed at the start of the pandemic, Kevin Allen’s at-home fitness app, Row Vigor, went gangbusters. But there was a problem -- a few lines of code were preventing Kevin from cashing in. The investors present at Kevin's original pitch were Phil Nadel, Jillian Manus, Dan ... Show More
32m 43s
Apr 2022
Postgres.js
Rasmus Porsager created Postgres.js –the fastest full-featured PostgreSQL client for Node.js and Deno. Today he joins Jerod for a deep-dive on Postgres, why he created this open source library, and how you can use it to build pg-backed JavaScript applications. Discuss on Changelo ... Show More
50m 6s
Jul 2020
"GraphQL is the bacon that'll make everything better" (JS Party #134)
KBall, Jerod, and Nick Nisi dive into GraphQL -- what it can do, what the challenges are, and how it differs from REST -- all with a generous helping of metaphor about buffets, restaurants, and of course bacon. 
54m 13s
Sep 2022
Kubernetes Unpacked 010: Troubleshooting And Alerting On Kubernetes
In this episode, Michael catches up with Natan Yellin, CEO of Robusta.dev. Michael and Ned chat about how logging and troubleshooting works in Kubernetes today. They discuss three stages of troubleshooting evolution - manual playbooks, automatic playbooks, and the third stage, wh ... Show More
39m 42s