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