Tanel Poder 🇺🇦
@TanelPoder
Creator of http://0x.tools and a long time computer performance nerd. Performance & Troubleshooting Training: https://learn.tanelpoder.com
You might like
New blog: xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 - Cardinality Misestimates) tanelpoder.com/posts/xb-sql-s…
So true. Many talk about the great O(log N) without realizing that their range scan has to get the rows scattered in a large table, for each index entry, and must do it one after the other if they want to preserve the order
When explaining database B+ trees, so many resources focus solely on keys, but fail to discuss what the actual values are. Does the tree store the actual row contents, or only references to rows stored elsewhere? Turns out, it can be both! Some databases do the former, for…
(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-s…
Things have come a long way since 1988. Some of the seminal papers and work was done around that time. Most of the ideas have stood the test of time.
This is one of the clearest breakdowns of idempotency keys I’ve read in a long time. Summary of the post (for anyone skimming): > Exactly-once delivery in distributed systems is impossible. > Exactly-once processing is possible with idempotency keys. > UUIDv4 works but forces…
📝 Blogged: "On Idempotency Keys" Discussing several options for ensuring exactly-once processing in distributed systems using idempotency keys, from UUIDs to monotonically increasing sequences. 👉 morling.dev/blog/on-idempo…
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 has built scripts to show misestimates in Oracle plans tanelpoder.com/posts/xb-sql-s…
One week left till the end of the Black Friday sale of my self-paced video learning courses! 🤓
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-fr…
Spend 15-30 minutes flipping through this. It's brilliant.
Benedict Evans' new presentation just dropped: "AI eats the world" 90 slides on macro and strategic trends in tech. His biannual overview is always worth the time: ben-evans.com/presentations
Mind officially blown 🤯 You can now generate real, scannable QR codes... using pure SQL in PostgreSQL. No extensions, no external libs — just raw SQL wizardry! Check out pqr.sql by @tanelpoder: tanelpoder.com/posts/generate… Run it like:
Oracle's event 10298 has been renamed in 23ai: "ORA-10298: Enable Oracle Server I/O module tracing." It traces physical I/O requests, reasons and file/block numbers, even when there's no wait, or the wait event doesn't report file/block/object numbers. Relevant links in reply.
Just got access to @PlanetScale's new $5/mo tier and this is a game changer! Feels like a no brainer move to launch a SaaS with PS from day 1. I'm a customer of PS but this new tier is crazy $5 is LITERALLY the price of a VPS but with the peace of mind at night! Insane 🤯
LinkedIn needs keyword blocking so I could block keywords like ✅, ❌, ✔, etc 🤔
Ridiculously common - developers want faster databases but don’t bother optimising round-trips to their database (the real killer) This is why PostgREST is powerful - advanced logic usually gets bundled into an RPC (and why we continue to refute client-side transactions)
Database queries were slow. All blamed the DB. RDS was fine. 12% CPU. Query times under 10ms. Turns out we were making 47 sequential queries per page load. Each one fast. Together? 470ms of just waiting. Fixed with one SQL JOIN. Performance problem was in application logic,…
This is gold if you're using async Rust 💯 🌀 channels-console — A TUI dashboard for inspecting std/tokio/futures/crossbeam channels. 📊 Watch messages, queue depth, throughput & memory usage live. 🦀 Written in Rust & built with @ratatui_rs ⭐ GitHub: github.com/pawurb/channel……
Multiple, serious security vulnerabilities found in the Rust clone of Sudo — which shipped with Ubuntu 25.10 (the most recent release). Not little vulnerabilities: We’re talking about the disclosure of passwords and total bypassing of authentication. In fact, we’re getting new…
📚 New Reading List is out! This week, we have a lot of #technical #details for #Oracle #Database, #OCI and Oracle #Linux Happy reading! geraldonit.com/reading-list-n…
I think you're missing transactions with the "WHERE updated_at >" approach. "updated_at" is the NOW() at the time of the update, but it's visible at the time of COMMIT. If you read in between the two, you don't see it, and the next read, at the new time, will also miss it
One of #P99CONF's most highly rated speakers is @tanelpoder. This year, Tanel launched the prod/GA ready version of xCapture v3 + xtop and demonstrated how it helps with real life troubleshooting scenarios. Watch the entire session for free: ow.ly/QfGR50XpsSN #ScyllaDB
United States Trends
- 1. Good Sunday 72K posts
- 2. Wirtz 13.4K posts
- 3. #AskFFT N/A
- 4. Ole Miss 42.8K posts
- 5. Gakpo 12.2K posts
- 6. #sundayvibes 5,451 posts
- 7. Vidal 3,635 posts
- 8. Isak 21K posts
- 9. Lane Kiffin 52.7K posts
- 10. Zirkzee 25.7K posts
- 11. #MUFC 19.8K posts
- 12. Neal 4,792 posts
- 13. #CRYMUN 9,371 posts
- 14. Amorim 44.7K posts
- 15. Duke 34.5K posts
- 16. Crystal Palace 39.5K posts
- 17. West Ham 6,014 posts
- 18. Stockton 33.1K posts
- 19. #AskBetr N/A
- 20. Full PPR N/A
You might like
-
Ask TOM for Database/SQL
@OracleAskTOM -
Jonathan Lewis
@JLOracle -
Franck Pachot
@FranckPachot -
Connor on SQL and Database
@connor_mc_d -
Mike Dietrich
@MikeDietrichDE -
Maria Colgan
@SQLMaria -
Frits Hoogland
@fritshoogland -
Martin Bach
@MartinDBA -
Tim Hall ∞🐵+∞⌨️
@oraclebase -
Oren Nakdimon
@DBoriented -
Markus Michalewicz
@KnownAsMarkus -
Chris Saxon
@ChrisRSaxon -
SQL.ProductManager.Oracle.Databases
@thatjeffsmith -
Pete Finnigan
@petefinnigan -
VLDB Bayliss
@vldbb
Something went wrong.
Something went wrong.