I'm not familiar with RethinkDB, but I have read the H-Store paper and I think some of its optimizations are applicable to RAM but not SSD. SSDs are much faster than disk, but I don't think they're fast enough that you can afford to eliminate caching or locking. In particular, good SSDs are internally parallel and require multiple concurrent I/Os for good performance, so you'll probably have to execute multiple transactions concurrently.