Re: jsonb and nested hstore

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: jsonb and nested hstore
Дата
Msg-id 5320C9AF.6070505@agliodbs.com
обсуждение исходный текст
Ответ на Re: jsonb and nested hstore  (Peter Geoghegan <pg@heroku.com>)
Ответы Re: jsonb and nested hstore  (Tomas Vondra <tv@fuzzy.cz>)
Список pgsql-hackers
Andrew, Peter:

Just so I'm clear on the limits here, lemme make sure I understand this:

a) GIN indexing is limited to ~~1500chars

b) The "value", which includes everything other than the top level set
of keys, is one item as far as GIN is concerned.

Therefore: we are limited to indexing JSON where nothing below a
top-level key is more than 1500bytes?

I'm asking for documentation purposes.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: Replication slots and footguns
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: jsonb and nested hstore