On Fri, Mar 21, 2014 at 7:23 AM, Peter Geoghegan <pg@heroku.com> wrote:
I must admit that I'm coming around to the view that jsonb_hash_ops would make a better default. Its performance is superb, and I think there's a strong case to be made for that more than making up for it not supporting all indexable operators - the existence operators just aren't that useful in comparison
Is there any \d command that would display a nice list of which operators a given operator class actually supports? It's kind of hard to determine whether a proposed index would actually be useful for your queries without it.