How much faster is Redis at storing a blob of JSON compared to PostgreSQL? 16×(peterbe.com)

3 ポイント投稿者 chtitux7 年前2 コメント

How much faster is Redis at storing a blob of JSON compared to PostgreSQL? 16×

https://www.peterbe.com/plog/redis-vs-postgres-blob-of-json

2 コメント

And did the OP try using Postgres with enough RAM allocated to it so that it could keep the entire database in memory?

In one test I’ve done, I saw running a full report going from taking five hours to just fifteen minutes. Which, coincidentally, is a factor if 20x.

So, maybe he could see comparable speeds, if he gave Postgres the ability to do the read and store operations the same way that Redis does?

alsadi7 年前

How about making it redis+msgpack vs. postgresql json-like?