3 ms·
> Jsonb has several missing useful features (from nested hstore), but that could be added later as an extension. Which are those missing useful features?
by skrause 13y ago
> Jsonb has several missing useful features (from nested hstore), but that could be added later as an extension.
Which are those missing useful features?
- craigkerstiens 13y agoAll of the equivalent operators don't exist, though those are only slightly interesting. Perhaps most interesting would be all the index types, right now currently GIN works, but GiST didn't quite make it. GIN was definitely showing the better performance on JSONB but there are still valuable cases for GiST which often appears smaller on disk.
- magnush 13y agoAnother important part about gist is that GIN has much higher overhead for tables that are frequently updated.