⬅︎ Back to How much faster is Redis at storing a blob of JSON compared to PostgreSQL?
Are the two databases both filled to the same size? There might be a scale difference if Postgres is looking through logs more data. And also the indexing that is done. Straight speed has tons of context.
No, they were not. PG had about 3GB worth of data. The Redis was only a couple of hundred megabytes. Lookup by primary key is always indexed.
Comment
Are the two databases both filled to the same size? There might be a scale difference if Postgres is looking through logs more data. And also the indexing that is done. Straight speed has tons of context.
Replies
No, they were not. PG had about 3GB worth of data. The Redis was only a couple of hundred megabytes.
Lookup by primary key is always indexed.