Search Postgresql Archives

Re: Computed index on transformation of jsonb key set

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




> On Apr 26, 2019, at 2:33 PM, Rob Sargent <robjsargent@xxxxxxxxx> wrote:
> 
> 
> On 4/26/19 3:25 PM, Steven Schlansker wrote:
>> 
>> 
>> How can I efficiently implement the feature I've described?  It seems difficult to use computed indexing with GIN.
>> 
> Storing the map in a child table (parentId, UUID, int) is out of the question?

Yes, thanks Rob and David, that will be my approach if I can't figure out anything better.

I was hoping to not have to denormalize the data given that Postgres generally has great support for computing indexes,
both to avoid storage costs and eliminate the need to maintain triggers or application code to handle it.







[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux