How much faster is Redis at storing a blob of JSON compared to PostgreSQL? 16× (opens in new tab)

(peterbe.com)

3 pointschtitux6y ago2 comments

2 comments

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?

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

j / k navigate · click thread line to collapse

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?

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

j / k navigate · click thread line to collapse