The Danger of Defaults - A PostgreSQL St...

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

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 

This new PostgreSQL 17 feature is game changer. They know can combine IOs when performing sequential scan. Grab my database coursehttps://courses.husseinnasser.com 

If you love taking about databases, this is the episode for you. Ahead of the launch of his new book, High Performance PostgreSQL for Rails, Andrew Atkinson joined the show with special guest co-host, Pat Bair, to talk about why he wrote a book, why he focused on PostgreSQL and h ... Show More

Tik Tok | Instagram | YouTube In today's episode, I explore the intriguing "Trigger > Thought > Action > Consequence" model that governs our daily decisions and actions. I introduce this process, illustrating its components with familiar examples like snacking habits, reactions t ... Show More

- pganalyze: https://pganalyze.com/- Weekly series "5mins of Postgres": https://www.youtube.com/channel/UCDV_1Dz2Ixgl1nT_3DUZVFw- How Postgres chooses which index to use: https://pganalyze.com/blog/how-postgres-chooses-index- CMU databases courses: https://db.cs.cmu.edu/courses/- ... Show More

It's been a minute since we've chatted :' ) If you're wondering where I've been, I took an 8 month hiatus from the podcast... and life because I was going thru it tbh 😭😭 But I'm back! And as we approach the one-year mark since the beginning of what I like to call "my downfall," ... Show More

Guy and Eitan talk about some great things about SQL Server, and mostly Guy’s experience in digging into execution plans and generating synthetic IO workloads. Relevant links: What’s new in SQL Server and Azure SQL 2023 Year in Review Multi-Tenancy in the Real World | Eitan Blumi ... Show More

If you start a new Rails project today, you’re probably going to pick Postgres for your database. And if you have a ten year old Rails app, you might be using MySQL. But Rails ships with support for SQLite, a lightweight SQL database. Can that lightweight database be used to make ... Show More

In this episode, we delve into the significant update allowing users to interact with ChatGPT without needing an account, marking a pivotal change in accessibility and user privacy. I'll explore the implications of this shift, including how it might affect user experience and ... Show More

Guy tries to convince Eitan that OPTION(RECOMPILE) is the ultimate "Turbo" button in SQL Server, and that it's strongly underappreciated. Relevant links for more info: OPTION(RECOMPILE) (Transact-SQL) - SQL Server | Microsoft Learn Recompile a Stored Procedure - SQL Server | Micr ... Show More

In this episode of Syntax, Wes and Scott talk through the ways they improved performance on the Syntax.fm website, how they knew it was slow to begin with, and the various changes they made to caching, and loading transcripts to improve the speed of the site. Show Notes 00:25 Wel ... Show More