Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

> Jsonb has several missing useful features (from nested hstore), but that could be added later as an extension.

Which are those missing useful features?



All 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.


Another important part about gist is that GIN has much higher overhead for tables that are frequently updated.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: