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
Oct 3
Asynchronous IO in Postgres 18
Postgres 18 has been released with many exciting features such as UUIDv7, Over explain module, composite index skip scans, and the most anticipated asynchronous IO with worker and io_uring mode which I uncover in this show. Hope you enjoy it0:00 Intro1:30 Synchronous vs Asynchron ... Show More
41m 12s
Jun 2025
kTLS - Kernel level TLS
Fundamentals of Operating Systems Course https://oscourse.winktls is brilliant.TLS encryption/decryption often happens in userland. While TCP lives in the kernel. With ktls, userland can hand the keys to the kernel and the kernel does crypto. When calling write, the kernel encryp ... Show More
22m 55s
May 2025
The beauty of the CPU
If you are bored of contemporary topics of AI and need a breather, I invite you to join me to explore a mundane, fundamental and earthy topic.The CPU.A reading of my substack article https://hnasr.substack.com/p/the-beauty-of-the-cpu 
9m 38s
Recommended Episodes
Sep 2023
How to write high-performance SQL for your Postgres database
pgnanalyze helps users deliver consistent PostgreSQL performance and availability at any scale. Get started with a free trial or explore their docs. You can also find them on YouTube, where Lukas posts a weekly show called 5mins of Postgres.Lukas was a founding engineer of Citus ... 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. Show ... Show More
1 h
Oct 2024
Big data is dead, analytics is alive
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 datab ... 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. Leave us a commentChangelog++ members save 9 minutes ... Show More
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
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 ac ... Show More
52m 2s
Aug 2024
Where does Postgres fit in a world of GenAI and vector databases?
For the last two years, Postgres has been the most popular database among respondents to our Annual Developer Survey. Timescale is a startup working on an open-source PostgreSQEL stack for AI applications. You can follow the company on X and check out their work on GitHub. You ca ... Show More
24m 38s