Re: json indexing and data types

On 12/2/15 7:06 PM, Merlin Moncure wrote:
>  > The basics is, that I have a column with what is essentially json data; a
>  > number of data structures of different depths. Perhaps 10 - 30 top
> levels,
>  > and probably no more than 3, max 4 levels deep. In total there are some
>  > hundred thousands of rows in each table. It would probably be best
> stored as
>  > jsonb. Right now it's text, because it's only used by the application
>  > itself.

After re-reading this part...

Are you in control of the JSON itself, and are the number of
permutations known in advance? It might be that something like table
inheritance is a better solution...
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com