Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on How much faster is Redis at storing a blob of JSON compared to Postgres?. Parent comment
If the index used are sensitive to low key diversity, fix that, and maybe shard.
You might prefer a vm type with nvme.
If u can divide the data into more small ones, more indexes and cache fits in ram.
Also, cluster data by what works, time, region, userclass, etc.
Only decompress the blobs at point of use.
Design your app to need only small fast data which cant be cached.
Etc
There are no comments on this comment yet.
If the index used are sensitive to low key diversity, fix that, and maybe shard.
You might prefer a vm type with nvme.
If u can divide the data into more small ones, more indexes and cache fits in ram.
Also, cluster data by what works, time, region, userclass, etc.
Only decompress the blobs at point of use.
Design your app to need only small fast data which cant be cached.
Etc