On Wed, Jan 28, 2015 at 3:03 PM, Josh Berkus <j...@agliodbs.com> wrote: > We already have most_common_elem (MCE) for arrays and tsearch. What if > we put JSONB's most common top-level keys (or array elements, depending) > in the MCE array? Then we could still apply a simple rule for any path > criteria below the top-level keys, say assuming that any sub-key > criteria would match 10% of the time. While it wouldn't be perfect, it > would be better than what we have now.
Well, the "top-level keys" would still be gathered for expression indexes. So yeah, maybe it would work alright for arrays of "tags", and things like that. I tend to think that that's a common enough use-case. -- Regards, Peter Geoghegan -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
