logo
episode-header-image
Feb 2024
11m 34s

The Danger of Defaults - A PostgreSQL St...

Hussein Nasser
About this episode

I talk about default values and how PostgreSQL 14 got slower when a default parameter has changed. Mike's blog https://smalldatum.blogspot.com/2024/02/it-wasnt-performance-regression-in.html



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
Jan 2024
Episode 159 - Select * Wastes Money
Guy and Eitan discuss various practices in SQL Server that hurt performance and possibly waste money, negative VarDecimal numbers, renumbering Identity columns, and the new Azure Database Fleet Manager. Relevant links: SQL Server IN Clause With Multiple Literal Values Performance ... Show More
37m 55s
Jul 2023
Episode 154 - Beavers and very loud farts
Guy and Eitan discuss several interesting topics and recent experiences that you'd want to hear about! Relevant links: Trigram Wildcard String Search in SQL Server The Story of DBeaver, PostgreSQL, and the silly data engineer SQL Server Error Log Management High VLF Counts Got Yo ... Show More
37m 14s
Sep 2023
Automated Deployments and the Art of the Database with Database Michael J Swart
<p>In this episode, Michael J Swart joins the Dear SQL DBA podcast to talk about databases, automation, and how he's come to illustrate some of the coolest blog posts ever to be written about data.</p> <p>Check out Michael's art and blog posts at <a href= "https://michaeljswart.c ... Show More
1h 5m
Nov 2025
Jake’s Notebook | How High Performance Began & Why Depth Is the New Currency
This week, I open my notebook to share how walking away from TV changed my life — and why ego nearly cost me purpose. I break down what’s really driving the future of podcasting, and the one thing that matters more than audience size: trust. Plus, a reminder that who you choose t ... Show More
22m 20s
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
Nov 2023
Hidden dilemmas
S02E07 (#317). A slightly different linkshow featuring two articles, one by James and one by Per. The articles in this episode are about how the experience of a delayed flight highlights the wider impact of poor service design, and how the way in which you type can reveal who you ... Show More
31m 4s
Jul 2025
Monologue: The Updated Pale Horses of the AIpocalypse
In this week’s monologue, Ed Zitron walks you through the pale horses of the AIpocalypse - and how the AI bubble’s deepest weakness is that it’s almost entirely based on vibes. Anthropic’s new data center in Indiana: https://www.nytimes.com/2025/06/24/technology/amazon-ai-data-ce ... Show More
14m 27s
Apr 2023
#1028: Databases
<p>In this podcast, I talk about one of the most important tools we use for Magic design—databases. I walk through the history of our databases and explain how we use them.</p> 
30m 52s
Jun 2020
Hasty Treat - Developing for Slow and Spotty Connections
In this Hasty Treat, Scott and Wes talk about how to develop for slow internet connections. LogRocket - Sponsor LogRocket lets you replay what users do on your site, helping you reproduce bugs and fix issues faster. It’s an exception tracker, a session re-player and a performan ... Show More
16m 19s