Re: jsonb and nested hstore - Mailing list pgsql-hackers

From Greg Stark
Subject Re: jsonb and nested hstore
Date
Msg-id CAM-w4HMeqWJ64nxa2Wp6myJ=FUt8wSgAj6stbsms4tt68UKQxg@mail.gmail.com
Whole thread Raw
In response to Re: jsonb and nested hstore  (Peter Geoghegan <pg@heroku.com>)
List pgsql-hackers

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.


--
greg

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [RFC] What should we do for reliable WAL archiving?
Next
From: Robert Haas
Date:
Subject: Re: QSoC proposal: Rewrite pg_dump and pg_restore