All of the equivalent operators don't exist, though those are only slightly inte...

craigkerstiens on March 24, 2014 | parent | context | favorite | on: PostgreSQL: Jsonb has committed

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 on March 24, 2014 [–]

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