Re: json datatype and table bloat?

Поиск
Список
Период
Сортировка
От David Johnston
Тема Re: json datatype and table bloat?
Дата
Msg-id 1383588891184-5776880.post@n5.nabble.com
обсуждение исходный текст
Ответ на json datatype and table bloat?  (Adam Jelinek <ajelinek@gmail.com>)
Ответы Re: json datatype and table bloat?  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
ajelinek@gmail.com wrote
> Along the lines of the equality operator; I have ran into issues trying to
> pivot a table/result set with a json type due what seemed to be no
> equality
> operator.

For the curious, and also use-case considerations for development, would you
be able to share what it is you are doing (and how) that combines full json
documents with pivoting?

Compound types holding source data for a pivot seems problematic since
generally all the pivot components are single-valued and, for data, often
numerical.

David J.





--
View this message in context:
http://postgresql.1045698.n5.nabble.com/json-datatype-and-table-bloat-tp5776182p5776880.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


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

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: table lock when where clause uses unique constraing instead of primary key.
Следующее
От: "Janek Sendrowski"
Дата:
Сообщение: Suitable Index for my Table