A lot of DB optimizations are almost invisible to the user, yet have a profound impact on performance. Like what Omnigres does with their query caching feature.

DBOS will definitely be an interesting thing to watch out for, if it looks to make things available at a low level.