logo
episode-header-image
Apr 2025
27m 36s

Sequential Scans in Postgres just got fa...

Hussein Nasser
About this episode

This new PostgreSQL 17 feature is game changer. They know can combine IOs when performing sequential scan.

Grab my database course

https://courses.husseinnasser.com


Up next
Yesterday
CPU and Kernel Page Faults
<p>Page faults occurs when the process tries to access a memory that isn’t backed by a physical page kernel raises a fault which loads a page. It happens on first access, stack expansion, COW, swap and much more. However it comes with a cost. </p><p><br /></p><p>In this episode o ... Show More
48m 37s
Oct 31
Amazon US-EAST-1 Outage in Details
On October 19 2025 AWS experienced an outage that lasted over a day, 10 days later we finally got the root cause analysis and we know exactly what caused the DNS to fail0:00 Summary 5:30 How did Dynamo lost its DNS?13:41 EC2 Errors 16:16 Network Load Balancer ErrorsRCA here https ... Show More
24m 26s
Oct 17
Graceful shutdown in HTTP
There are cases where the backend may need to close the connection to prevent unexpected situations, prevent bad actors or simply just free up resources. Closing a connection gracefully allows clients and backends to clean up and finish any pending requests. In this episode of th ... Show More
25m 49s
Recommended Episodes
Sep 2023
How to write high-performance SQL for your Postgres database
<p><a href="https://pganalyze.com/" target="_blank">pgnanalyze</a> helps users deliver consistent <a href="https://www.postgresql.org/" target="_blank">PostgreSQL</a> performance and availability at any scale. Get started with a <a href="https://app.pganalyze.com/users/sign_up" t ... Show More
24m 44s
Aug 2024
803: The SQLite Takeover with Turso’s Glauber Costa
Scott and Wes chat with Glauber Costa from Turso about the evolution of databases and the fascinating technology behind Turso. They dive into topics like the benefits of massive multi-tenancy, vector search, and why Glauber made the switch from NoSQL to relational databases. Sho ... Show More
1 h
Oct 2024
Big data is dead, analytics is alive
<p>We are on the other side of “big data” hype, but what is the future of analytics and how does AI fit in? Till and Adithya from MotherDuck join us to discuss why DuckDB is taking the analytics and AI world by storm. We dive into what makes DuckDB, a free, in-process SQL OLAP da ... Show More
50m 19s
Jun 2024
Apple’s AI Announcements, Apple Intelligence, The Real Personal AI Assistant
After a long wait, Apple is finally in the game with AI. They’re launching Apple Intelligence with MacOS Sequoia and iOS 18. Pete breaks down some top features and how our devices will change moving forward. Transcripts: ⁠https://www.theneuron.ai/podcast⁠ Subscribe to the best ne ... Show More
12m 30s
Dec 2024
The Art of Database Selection and Evolution
Summary In this episode of the Data Engineering Podcast Sam Kleinman talks about the pivotal role of databases in software engineering. Sam shares his journey into the world of data and discusses the complexities of database selection, highlighting the trade-offs between differen ... Show More
59m 56s
Aug 2024
Picking a database should be simple (Changelog & Friends #56)
Database aficionado, Ben Johnson, joins Jerod to answer the age ol' question: which database should you use? Answering that isn't always easy, which means it's time to play the "It Depends" jingle & weigh (some of) the options. 
1h 6m
Sep 18
From RAG to Relational: How Agentic Patterns Are Reshaping Data Architecture
SummaryIn this episode of the AI Engineering Podcast Mark Brooker, VP and Distinguished Engineer at AWS, talks about how agentic workflows are transforming database usage and infrastructure design. He discusses the evolving role of data in AI systems, from traditional models to m ... Show More
52m 58s
Jan 2025
#704: #704: Scaling your relational database on AWS - Are relational databases cool again?
Are relational databases cool again? In this episode of the AWS Podcast, host Simon Elisha sits down with Josh Hart, Principal Solutions Architect at AWS, to explore how traditional databases are getting a modern makeover. They dive into three game-changing innovations from AWS t ... Show More
23m 43s
Nov 2024
scikit-learn & data science you own
<p>We are at GenAI saturation, so let’s talk about scikit-learn, a long time favorite for data scientists building classifiers, time series analyzers, dimensionality reducers, and more! Scikit-learn is deployed across industry and driving a significant portion of the “AI” that is ... Show More
52m 2s
Aug 2024
Where does Postgres fit in a world of GenAI and vector databases?
<p>For the last two years, Postgres has been the <a href="https://survey.stackoverflow.co/2024/technology/#1-databases" target="_blank">most popular database</a> among respondents to our Annual Developer Survey. </p><p>Timescale is <a href="https://www.timescale.com/ai" target="_ ... Show More
24m 38s