On Fri, Mar 14, 2014 at 9:17 PM, Josh Berkus <j...@agliodbs.com> wrote: > On 03/14/2014 06:44 PM, Tomas Vondra wrote: >> Stupid question - so if I have a json like this: > > Not a stupid question, actually. In fact, I expect to answer it 400 or > 500 times over the lifespan of 9.4. > >> { "a" : { "b" : "c"}} >> >> the GIN code indexes {"b" : "c"} as a single value? And then takes "c" >> and indexes it as a single value too? > > I don't know that "c" is indexed separately. > >> Because otherwise I don't understand how the index could be used for >> queries with @> '{"a" : {"b" : "c"}}' conditions (i.e. path "[a,b]" with >> value "c"). >> >> Hmmmm, if that's how it works, removing the size limit would be >> certainly more difficult than I thought. > > Precisely. Hence, the Russian plans for VODKA.
Have these plans been shared publicly somewhere? Got a link? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers