New blog: xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 - Cardinality Misestimates) https://t.co/UO1BKpTpHn

A generational leap in innovation!

eBPF-driven diagnostic tool for Kubernetes applications 🐝

@archeologistdev @samlambert @glcst @jorandirkgreef @TigerBeetleDB Not stored procedures, but database lambdas!

@MartinDBA «database lambdas (a term that sounds so much better than stored procedures)» 🤣🤣🤣

@mortenbraten I think it was @TanelPoder who came up with it first-credit where credit is due

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: https://t.co/XYqI13bvQd #ScyllaDB

@gunnarmorling 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" https://t.co/LTJMbrjG8T

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

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 https://t.co/lU91tclnDf

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

@TanelPoder @samlambert @glcst @jorandirkgreef @TigerBeetleDB

Spend 15-30 minutes flipping through this. It's brilliant.

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: https://t.co/zufoV1BFzr 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.

emacs https://t.co/8UeA6XQc28

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 🤔