Re: json datatype and table bloat? - Mailing list pgsql-general

From David Johnston
Subject Re: json datatype and table bloat?
Date
Msg-id 1383588891184-5776880.post@n5.nabble.com
Whole thread Raw
In response to json datatype and table bloat?  (Adam Jelinek <ajelinek@gmail.com>)
Responses Re: json datatype and table bloat?
List 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 by date:

Previous
From: Rob Sargent
Date:
Subject: Re: table lock when where clause uses unique constraing instead of primary key.
Next
From: "Janek Sendrowski"
Date:
Subject: Suitable Index for my Table