We should convert all json database columns (attrs etc.) to jsonb (also from modules). This will speed up queries based on these columns. This article says that the only reasons to use json would be if you have lots of INSERTs, no queries based on the columns or the JSON indentation should be preserved. None of these apply to us.
We should convert all json database columns (
attrsetc.) to jsonb (also from modules). This will speed up queries based on these columns. This article says that the only reasons to use json would be if you have lots of INSERTs, no queries based on the columns or the JSON indentation should be preserved. None of these apply to us.