3 ms·
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'r
by bradhe 7y ago
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.
- sandGorgon 7y agopostgres 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.87926%40wrigleys.postgresql.org https://www.postgresql.org/message-id/20140801182102.2696.87... if possible, this benchmark should be run again with a largish TOAST_TUPLE_TARGET
- bradhe 7y agohttps://wiki.postgresql.org/wiki/TOAST https://wiki.postgresql.org/wiki/TOAST