“I was surprised that there's a threshold. And once I saw the threshold, it makes sense to warn people. You test this in your own little environment, not thinking twice about growth. … Once UUID 4 is running for a while and the index size is growing, once it just consumes all the memory, it kicks the table out of memory.”
sputnikintelligence.com
Asked what surprised him in their UUIDv4 versus UUIDv7 benchmarks. His answer is the cliff: a team can test the two, see little difference, and then hit a sudden slowdown once the index outgrows memory.
…right? Not necessarily a tech problem. Now you want to get the numbers out. And so then you ran it. So obviously the int 8 being faster kind of surprised you, turned out to be a false alarm. What else surprised you, Nick, in the results? So now it collected a bunch of results. What surprised you?
I don't think I was super surprised. I saw roughly what I expected. What surprised me that it caught itself, like on this mistake and corrected itself, and I just observed it. This I like a lot. So
I'll be honest, I was surprised. I was surprised that there's a threshold. And once I saw the threshold, it makes sense to warn people. You test this in your own little environment, not thinking twice about growth. And if you're a starter. Startup, you can make a mistake I've seen many startups make. And it's like, oh, this is what UUID 4, UUID 7 are about the same. And you turn around and find out that the, and this came out of the results, and it surprised me. Once UUID 4 is running for a while and the index size, while it's growing, once it just consumes all the memory, it kicks the table out of memory.
And then all of a
sudden it starts writing to disk, and its performance is no longer the same as when it was all in memory. Now, that makes sense. That's a
good point. Yeah, I agree with you. This is a super interesting first thing, first finding, right? So if you watch us on YouTube or listen, if we're still in your pocket, just check out the graph which pops out on the screen right now. And regular podcast listeners follow the link, so you will see…