How much faster is Redis at storing a blob of JSON compared to PostgreSQL? 16× (peterbe.com) 3 points by chtitux 6y ago ↗ HN
[–] bradknowles 6y ago ↗ 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?
2 comments
[ 3.4 ms ] story [ 17.5 ms ] threadIn 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?