News for hackers. Stuff that matters.

A comment on How much faster is Redis at storing a blob of JSON compared to Postgres?. Parent comment

Re:How much faster is Redis at storing a blob of JSON compar... by mslot on Wednesday October 02, 2019 @11:29AM (#21137503)
Looking up a row of JSONB data by a primary key in a 3GB PostgreSQL table on my laptop takes 0.4-0.5ms, since it easily fits in memory and Postgres caches the data.
[ Parent | on HN ]
Re:How much faster is Redis at storing a blob of JSON compar... by bufferoverflow on Wednesday October 02, 2019 @05:24PM (#21140899)
If it fits in RAM, you might as well put it in memcached. You will likely get a 10X speedup.

EDIT:

To be fair, RAM is cheap these days, and most real world projects fit into RAM without a crazy budget.

[ Parent | on HN ]
Re:How much faster is Redis at storing a blob of JSON compar... by mslot on Wednesday October 02, 2019 @06:39PM (#21141551)
Why even memcached? It's not going to be 10x faster than your typical LRU cache (e.g. Postgres' shared buffers). It might scale a little better, but you should only consider that when it's worth it.
[ Parent | on HN ]
Re:How much faster is Redis at storing a blob of JSON compar... by jjeaff on Wednesday October 02, 2019 @06:14PM (#21141340)
Ram is cheap everywhere but "cloud" instances. Was just noticing the other day, I can get about 128GB of ram on a dedicated instance for the same price I am paying in the cloud for 16GB.
[ Parent | on HN ]
Re:How much faster is Redis at storing a blob of JSON compar... by bufferoverflow on Thursday October 03, 2019 @05:34PM (#21152475)
Yeah, cloud prices are insane. I only rent individual servers.

Very few real world projects actually do need the cloud features. It's nice to have, sure, but you're paying a lot for it.

[ Parent | on HN ]