|
|
|
|
|
|
by buremba
3574 days ago
|
|
|
In fact, JSONB is probably not a good idea when it comes to analytics. The storage is almost x2, accessing attributes are expensive than tabular data even though JSONB is indexed, the data can be dirty (the client can send extra attributes or invalid values for existing attributes, since JSONB doesn't have any schema, Postgresql doesn't validate and cast the values) and as the author mentioned, Postgresql statistics and indexes don't play nicely with JSONB. |
|
|