Tanel Poder 🇺🇦

Almost Summer Sale 2026: All my flagship video courses discounted until end of May! Plus *free* Exadata Internals & Advanced Performance Metrics seminar videos! tanelpoder.com/posts/almost-s…

The vibe-upgrade seems to have succeeded!

This is in my local VM (with a complete snapshot taken), not production... in case anyone wonders

AI mildly frustrated by Oracle DB patching process?

(1/2) Engineers often face a trade-off between scaling fast and maintaining low latency. @P99CONF is designed specifically for those navigating the complexities of high-throughput, low-latency systems. #ScyllaDB #P99CONF

MotherDuck + DuckDB SF Meetup is back, May 21. Three talks: • Philip Moore (GizmoData) on GizmoSQL: wrapping DuckDB with Arrow Flight SQL so it runs as a server anywhere, including on an iPhone • Michael Driscoll (Rill Data) on rebuilding Rill Cloud around Quack, DuckDB's new client-server protocol, and what it does to the dev loop • Eddie A. Tejeda (HotData) on a DataFusion extension for DuckLake Co-hosted with Greybeam. RSVP: luma.com/motherduckdckd…

@ScyllaDB @gunnarmorling @Uber @chipro @AmpCode @dmarticus Should be fun (again)!

(2/2) Our free and virtual event brings leading experts like @gunnarmorling, @Uber's Janani Narayanan, @TanelPoder, @Chipro, @ampcode's Thorsten Ball, @Uber's Cristian Velasquez, and @dmarticus to discuss the latest winning strategies and best practices. p99conf.io/?latest_sfdc_c…

Almost Summer Sale 2026: All my flagship video courses discounted until end of May! Plus *free* Exadata Internals & Advanced Performance Metrics seminar videos! tanelpoder.com/posts/almost-s…

The LONG data type in Oracle Database is tricky to work with Sadly the partition high value column uses LONG 26ai added CLOB and JSON version of it But what if you're on older releases? @TanelPoder shows how to convert LONG to VARCHAR2 with PL/SQL tanelpoder.com/posts/oracle-g…

bpftop 0.9.0 is out. It now displays bpf_link_info for attached programs, and there's a new installer script. github.com/jfernandez/bpf…

A 30-year SQL issue: normalization requires joins across the relational schema, and for performance, those joins should run in the RDBMS, not in the application. But in-database joins do not raise NO_DATA_FOUND or TOO_MANY_ROWS... linkedin.com/posts/franckpa…

@trollied @lemire Some engines (talking about Oracle's In-Memory Database module with SIMD) dynamically load the shared library for appropriate architecture on engine startup... tanelpoder.com/2014/10/05/ora…

@lemire @TanelPoder Why can’t compilers make binaries that initially detect capabilities at runtime, and follow whatever code path that is supported?

Almost all x64 processors today (Intel/AMD) support advanced instructions such as BMI2, AVX2. Unfortunately, most Linux distributions give you code that is compiled to run on systems without these instructions. It means that you may get inferior performance. Many distributions like RedHat have begun defaulting on processors that have these advanced instructions. Recent versions of the popular Linux distribution Ubuntu offers version of your favourite software compiled with these advanced instructions (x86_64-v3 packages). Unfortunately, as far as I can tell, they are disabled by default and require some work to be enabled. I invite you to experiment.

Just in the nick of time, it's my round-up of Interesting Links for April 2026! There's links about all sorts of stuff around Data Engineering, CDC, Iceberg, Data architectures, and even a little hint of AI (but only the useful kind, not the gross hype-y kind). rmoff.net/2026/04/30/int…

@thatjeffsmith There are a few little known features about SQL Monitoring (both Exadata specific and general), currently working on some new material & a blog entry will follow at some point too :-)

@thatjeffsmith Haha, when I wrote this, was also wondering if anyone reads it "pretty decent" vs "recent" (and pretty awesome source of info and references)

A pretty recent summary article from Oracle on enabling and getting SQL monitoring reports in various ways (including historical captures): Real-Time SQL Monitoring: a MUST for SQL Tuning blogs.oracle.com/coretec/oracle… (I'm working on something new & related too ;-)

Looking to make your DuckLake lakehouse fly? DuckLake 1.0 shipped earlier this month! DuckLake is an open lakehouse format brought to you by the creators of DuckDB. The format is built to be simple and fast, and a few thoughtful configuration choices can take it to the next level. Tomorrow at 9am PT, Alex Monahan is going live to cover getting started, plus the settings and strategies to get your lakehouse going fast. Live Q&A too. Register: luma.com/ducklake-1-0?u…