NULL BITMAP by Justin Jaffray
Subscribe
RSS
Archive
Why Are Query Plans Trees?
October 2, 2023
Looking at just about any database's EXPLAIN output will reveal that generally, queries get compiled into tree-shaped plans, rather than general cyclic...
Internal Affairs
September 25, 2023
There is a trick called string interning that is well known to compiler authors, and sometimes shows up in other places as well. It's used to change the...
Unity and VLDB Reading List #2
September 18, 2023
Normies Learn Software Licensing If you're a software person and at all plugged in to the world of video games, you might have watched in horror as Unity...
VLDB Reading List #1: TUM Edition
September 11, 2023
VLDB just happened! And I have been going through some of the papers that caught my eye. As it turns out, this week is TUM week. What Modern NVMe Storage Can...
The Problem with Declarativity
September 4, 2023
IN or OR There was a very nice blog post from OtterTune [1] recently, digging into some of the quirks of the way Postgres executes a particular query: Query...
Hard and Soft Statistics
August 28, 2023
One lens I've found satisfying for "what is a query planner" is that it's a tool for "approximating domain knowledge." By that I mean, someone who knows...
The Halloween Problem
August 14, 2023
What if you had an isolation anomaly with yourself? If you're receiving this as an email, thank you for entrusting me with your email address, I know that's...
Cohost
GitHub
Website
Twitter