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!

Oracle 26ai¹ was released yesterday. From the SQL standpoint it's worth mentioning that is has got the QUALIFY clause: I bet this starts an avalanche (there are already PostgreSQL patches). modern-sql.com/caniuse/qual... ¹ 26ai is the marketing version, 23.26.0 is the technical version.

JIT: so you want to be faster than [the PostgreSQL] interpreter on modern CPUs www.pinaraf.info/2025/10/jit-...

This reminded me I've been sitting on draft blog posts about Copy-and-Patch JIT compilation for a while, and so I've finally published the first chunk of it: a minimal tutorial and explanation of how and why Copy-and-Patch actually works. Start at transactional.blog/copy-and-pat...

P99 CONF is next week! Which talks are on your "can't miss" list?

pqr.sql: Generate QR Codes with Pure SQL in PostgreSQL tanelpoder.com/posts/genera...

pqr.sql: Generate QR Codes with Pure SQL in PostgreSQL tanelpoder.com/posts/genera...

Seen in twitter from @tanelpoder.com :)

Blog post for September 2025 SQL Developer isn't entirely CBO-friendly. jonathanlewis.wordpress.com/2025/09/24/s...

💪 Monday motivation: We are officially one month away from #P99CONF. eBPF has always been a popular topic, and this year is no exception. Don't miss @tanelpoder.com, @ddelnano.bsky.social, Jake Hillion, and @mostlynerdless.de on October 22-23: www.p99conf.io?latest_sfdc_... #ScyllaDB

Two years ago I published a "book" on intro Python programming and host it free of charge at pyflo.net I occasionally get email like this. It's wonderful to know all those efforts are helping learners around the world.

If you have eBPF "biolatency" style IO latency monitoring tools always-on, you might want to reduce its tracepoint CPU overhead by not storing IO start times in a shared hashtable at all. In my results, 59x lower tracepoint CPU overhead at 37M IOPS 😎 tanelpoder.com/posts/optimi...

If you have eBPF "biolatency" style IO latency monitoring tools always-on, you might want to reduce its tracepoint CPU overhead by not storing IO start times in a shared hashtable at all. In my results, 59x lower tracepoint CPU overhead at 37M IOPS 😎 tanelpoder.com/posts/optimi...