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

Re:How much faster is Redis at storing a blob of JSON compar... by RedShift1 on Sunday April 18, 2021 @12:07PM (#26853636)

Interesting, thanks for your reply. How do you deal with timezones? In our case, for our default dashboard view, we could pre-aggregate everything per hour but often daily, weekly, monthly denominations are needed, which is where the timezone comes into play. Do you pre-aggregate every possible timezone or just update the views for each user individually?

[ Parent | on HN ]

Re:How much faster is Redis at storing a blob of JSON compar... by tomhoward on Sunday April 18, 2021 @02:01PM (#26854770)

Cheers!

The time series data is stored as arrays of two-item arrays: [UTC-timestamp-in-ms, value].

We have some aggregated and calculated displays by day/week/month/etc, and these are updated/cached when new data is uploaded, which normally only takes a few seconds or less for each view.

Data is shown to end-users in the timezone where the monitoring site is located, which normally is moot as the user looking at the data is located in the same timezone, but where they are not, the timezone is clearly identified on the graph/table.

[ Parent | on HN ]