3 ms·
I get all the comparison, but Redis? I still use Redis as a cache on top of my PostgreSQL queries. PostgreSQL simply can't be as fast as a K/V like Redis.
by jakearmitage 7y ago
I get all the comparison, but Redis? I still use Redis as a cache on top of my PostgreSQL queries. PostgreSQL simply can't be as fast as a K/V like Redis.
- smt88 7y ago> I still use Redis as a cache on top of my PostgreSQL queries Why? Postgres has a "Redis cache" (in-memory query cache) built in already[1]. Your application layer doesn't have to worry about query caching at all. 1. https://www.postgresql.org/docs/current/runtime-config-resource.html#GUC-SHARED-BUFFERS https://www.postgresql.org/docs/current/runtime-config-resou...
- jakearmitage 7y agohttps://www.peterbe.com/plog/redis-vs-postgres-blob-of-json https://www.peterbe.com/plog/redis-vs-postgres-blob-of-json
- ants_a 7y agoWhile I have no doubt that Redis is faster for slinging blobs around, that blog post is not great comparison of the technologies. Both Django ORM and Python psycopg2 driver are not performance oriented tools.
- jatone 7y agothis is so egress of a misrepresentation its absurd. redis in its default configuration is in memory. postgresql stores to disk. I doubt they was running anything in parallel. (python) if you tune postgres by using a RAM disk and actually use parallelism it blows redis out of the water hands down.
- jatone 7y agoyes it can. in fact it can be faster due to the fact it isn't single threaded. learn about table spaces and RAM disks.