⬅︎ Back to How much faster is Redis at storing a blob of JSON compared to PostgreSQL?
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.
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.
Comment
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.
Parent 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.