How much faster is Redis at storing a blob of JSON compared to Postgres?

Re:How much faster is Redis at storing a blob of JSON compar... by zzzeek on Wednesday October 02, 2019 @12:39PM (#21138358)

First off:

1. if you are claiming to compare PostgreSQL to Redis, do NOT test with django or SQLAlchemy or whatever, use the raw DBAPI driver, most likely psycopg2, but you might get much faster results with a more optimized driver like asyncpg.

2. Use the Python profiler to generate profiles and to actually see how much time is spent waiting on the network to get the value.

[ Parent | on HN ]

Re:How much faster is Redis at storing a blob of JSON compar... by gonational on Wednesday October 02, 2019 @04:07PM (#21140259)

Thanks for this! I did not know about asyncpg, which is purportedly an average of 3x faster than psycopg2.

[ Parent | on HN ]