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

Re:How much faster is Redis at storing a blob of JSON compar... by sandGorgon on Wednesday October 02, 2019 @11:22AM (#21137431)

postgresql does TOAST compression of large jsonb blocks. You might be incurring the cost of compression/decompression by postgresql

[ Parent | on HN ]

Re:How much faster is Redis at storing a blob of JSON compar... by bradhe on Wednesday October 02, 2019 @06:49PM (#21141612)

Uh...TOAST is a system for storing data off page. It doesn't have anything to do with compression? Reading a TOAST actually requires reading two pages, so you're correct that there is read and write overhead. But it isn't CPU bound a la compressing the data.

[ Parent | on HN ]

Re:How much faster is Redis at storing a blob of JSON compar... by sandGorgon on Thursday October 03, 2019 @08:04AM (#21146007)

postgres does TOAST compression of larger jsonb.

I dont have any direct link to the docs, but here's a bug report when such behavior was NOT happening.

https://www.postgresql.org/message-id/20140801182102.2696.87...

if possible, this benchmark should be run again with a largish TOAST_TUPLE_TARGET

[ Parent | on HN ]

Re:How much faster is Redis at storing a blob of JSON compar... by bradhe on Thursday October 03, 2019 @10:37AM (#21147493)

https://wiki.postgresql.org/wiki/TOAST

[ Parent | on HN ]