3 ms·
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 curren
by craigkerstiens 13y ago
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.
- magnush 13y agoAnother important part about gist is that GIN has much higher overhead for tables that are frequently updated.