modern-sql.com now covers DuckDB.

Happy Thanksgiving! Need a pod while washing dishes? New Oxide and Friends examines a bug introduced over 18 years ago. Performance is great but not—it turns out—without correctness oxide-and-friends.transistor.fm/episodes/gro...

(3 days left until the end of Black Friday Sale of my online training courses!) Also, an old post for Oracle nerds: "Oracle Shared Pool Internals: List Chunk Position in the LRU List" tanelpoder.com/posts/oracle...

When tuning #SQL, focus on the estimates for how many rows each operation will return If these are off by an order of magnitude or more, there's a good chance a different plan is faster @tanelpoder.com has built scripts to show misestimates in Oracle plans

One week left till the end of the Black Friday sale of my self-paced video learning courses! 🤓

cool job at a very special computer company - write TypeScript and Rust - everyone makes $235k - fully remote - everything is open source

Biggest takeaway from KubeCon: People want Neki badly. We're building the solution for scaling and managing huge Postgres databases. More to come, but in the meantime: neki.dev

Turns out you can communicate across containers via 63-bits of available space in a shared lock you acquire on /proc/self/ns/time that all processes have access to. No networking required. The post has a demo of a chat app communicating across unprivileged containers. h4x0r.org/funreliable/

Added a blog update about the V$PROCESS_MEMORY_DETAIL auto-population for processes with PGA growth to over 500MB. Enabled in Oracle 19.18+, so no "oradebug dump pga_get_detail" needed, just query the V$ views for a detailed "heapdump": tanelpoder.com/2014/03/26/o...

New scripts: vstat.sql & dstat.sql for showing Oracle Sysmetric history with 1-minute granularity (both from AWR and regular V$ views) tanelpoder.com/posts/oracle...

Added a blog update about the V$PROCESS_MEMORY_DETAIL auto-population for processes with PGA growth to over 500MB. Enabled in Oracle 19.18+, so no "oradebug dump pga_get_detail" needed, just query the V$ views for a detailed "heapdump": tanelpoder.com/2014/03/26/o...

New scripts: vstat.sql & dstat.sql for showing Oracle Sysmetric history with 1-minute granularity (both from AWR and regular V$ views) tanelpoder.com/posts/oracle...

FreeSQL.com now supports SQLNet connectivity for your free schema on both our 19c and 26ai database platforms.

A bunch of folks at Oxide uncovered a tricky deadlock associated with async Rust (yes, another!), so--of [email protected] and I got the crew together to discuss. If you're writing async Rust, you'll want to know how to avoid and diagnose "Futurelock"

This post is awesome eavan.blog/posts/implem...

In concept I’m a huge fan of porting infrastructural code to Rust/memory safe languages, but shipping broken code — especially code that causes silent data loss — doesn’t help that cause.

I just extended the Black Friday sale to the whole month of November! All my existing full-week flagship courses are heavily discounted for the entire month, and more content coming soon! tanelpoder.com/posts/black-...

New blog: xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 - Cardinality Misestimates) tanelpoder.com/posts/xb-sql...

New blog: xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 - Cardinality Misestimates) tanelpoder.com/posts/xb-sql...

I just extended the Black Friday sale to the whole month of November! All my existing full-week flagship courses are heavily discounted for the entire month, and more content coming soon! tanelpoder.com/posts/black-...

If you want to do *online* database schema migrations without degrading the performance of your system, the Expand and Contract Pattern is a great approach. And generally a great pattern to know about. www.prisma.io/dataguide/ty...

My colleague Dave Pacheco wrote up a great description of a new (to us?) Rust async pathology--"futurelock"--another extremely sharp edge to watch out for, with no particular guardrails. Of course, we'll be talking about it with @bcantrill.bsky.social on Monday's Oxide and Friends

The first deep dive in my new special-focus training series starts on Wednesday: "Handling the Optimizer, Statistics and Workloads on Partitioned Tables in Oracle Databases" (5-6 Nov 2025 + Q&A followup sessions). One demo table has 100k partitions ;-) Sign up here: tanelpoder.com/seminar/

ladies and gentlemen...we got him

The first deep dive in my new special-focus training series starts on Wednesday: "Handling the Optimizer, Statistics and Workloads on Partitioned Tables in Oracle Databases" (5-6 Nov 2025 + Q&A followup sessions). One demo table has 100k partitions ;-) Sign up here: tanelpoder.com/seminar/

The P99 CONF page is www.p99conf.io/session/xcap...

The developer VM has been freshened up! Go get some! www.oracle.com/database/tec...

AWS becoming the "millennial" cloud? A thing I'm sensing here and there: Early-stage startups don't bother onboarding to a cloud service like AWS. They instead go for more "hip" startups for web hosting and databases. Think Vercel, Render, Railway, Supabase They *might* move much later

... well, they might move later (to optimize infra costs), but they don't always do! Cursor is an example of one where they moved to AWS for databases... got burnt and moved to Turbopuffer + Planetscale: Are these one-offs or a trend? newsletter.pragmaticengineer.com/p/cursor

meatcoding (it's like vibecoding but instead you use meat that can think)

Since last week, I can finally use the QUALIFY clause in Oracle. If you never heard of this SQL extension, read my newest blog post: danischnider.wordpress.com/2025/10/24/q...

Previously on this show: Find which Oracle SQL_ID hits the SQL*Net break/reset to client event tanelpoder.com/posts/find-w...

Previously on this show: SQL Plan Execution FlameGraphs with Loop and Row Counts tanelpoder.com/posts/sql-pl...

endianness is just a plot by Big Endian to sell more byte swap operations

Morel is now in Rust! I just made the first release of the new Rust toolchain for Morel. Morel-Rust implements same language as Morel-Java. It's early days, but potentially performance will be much better. blog.hydromatic.net/2025/10/23/m...

😎

The 2nd day of @P99CONF starts in about an hour (11am EDT). I enjoyed yesterday's sessions! My eBPF "top for wall-clock time" talk starts in 4 hours (2:30pm EDT): www.p99conf.io/agenda/#thur... It's a free conference, see you soon! 🤓

Filtering data in real time (at CERN) After early filtering, this snippet from the article: "At this stage, the remaining events are recorded to a 40 Petabyte disk buffer." A 40 PB *buffer* for data 🫠 lhcb-outreach.web.cern.ch/filtering-da...

Announcing my new Oracle Optimizer, Partitioning and I/O-Intensive Database Handling Deep Dive Training! If you run serious Oracle workloads on-premises or in the cloud and want to learn some practical *and* new things this year, this is it! tanelpoder.com/posts/new-or...

Google DeepMind and UCL experts have released a 𝗳𝗿𝗲𝗲, hands-on curriculum for students. It covers the fundamentals of building and fine-tuning language models, including data preparation, neural networks, and the transformer architecture. Learn more: www.skills.google/collections/... #AI #MLSKY

Announcing my new Oracle Optimizer, Partitioning and I/O-Intensive Database Handling Deep Dive Training! If you run serious Oracle workloads on-premises or in the cloud and want to learn some practical *and* new things this year, this is it! tanelpoder.com/posts/new-or...

There's a new Data Guard in town (not the Oracle one). Cool to see Linkedin, OpenAI and Anthropic collaborating: arxiv.org/html/2502.01...

Method tracing in async-profiler 4.2 github.com/async-profil... Also there’s system-wide process sampling on linux, this ends up in a `profiler.ProcessSample` JFR event. (I would love to see something like that on Darwin too). github.com/async-profil... #async-profiler

Filtering data in real time (at CERN) After early filtering, this snippet from the article: "At this stage, the remaining events are recorded to a 40 Petabyte disk buffer." A 40 PB *buffer* for data 🫠 lhcb-outreach.web.cern.ch/filtering-da...

Missed some sessions at @OracleAIWorld? Here's the 2025 mega download of session content. Enjoy! connor-mcdonald.com/2025/10/21/t...

Coincidentally I've been looking at hybrid histograms in the last couple of days and started sketching some notes about the factors involved in calculating join cardinalities for two tables with four join predicates and a couple of non-join predicates. Then I realised how much work that would be!

tabhisthybrid.sql: Display Oracle hybrid histograms and filter cardinality estimates tanelpoder.com/posts/tabhis...

tabhisthybrid.sql: Display Oracle hybrid histograms and filter cardinality estimates tanelpoder.com/posts/tabhis...

Can We Know Whether a Profiler is Accurate? Spoiler: yes we can! But it took us figuring out a way to work around the fundamental observer effect. stefan-marr.de/2025/10/can-... If you're at SPLASH, don't miss our talk at VMIL today and at OOPSLA on Saturday!