They don't compare exactly. Author is mistaken in thinking that UNLOGGED means "in memory". It means "no WAL", so there's considerable speed up there, but traded in with also more volatility. To be a viable alternative to Redis or Memcached though, the savings you get from the latter two must really be superfluous to your use case. Which could be true for many (most?).