Query by regex not working in transaction

Is it possible (in other DBs) and makes sense to run tests without commit? That feels like a hacky way of testing things.

I’m not sure if that’s a good thing to keep transactions accessible in RAM through the cluster. That might consume a lot of RAM. I’m not against it but feels unusual. And if there’s is demand - why not?