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 Fri, Apr 26, 2019 at 2:25 PM Steven Schlansker <stevenschlansker@xxxxxxxxx> wrote:
How can I efficiently implement the feature I've described?  It seems difficult to use computed indexing with GIN.

Don't use a computed index?  Add a trigger to populate a physical column and index that.  Modify queries to make simple tests against the stored array.

David J.

[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