Re: Computed index on transformation of jsonb key set

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Steven Schlansker <stevenschlansker(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Computed index on transformation of jsonb key set
Date: 2019-04-26 21:32:15
Message-ID: CAKFQuwZ-WKzzCs_+3j7apv4agi8hsYjocTukQohb+aBFmqjieA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Apr 26, 2019 at 2:25 PM Steven Schlansker <
stevenschlansker(at)gmail(dot)com> 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2019-04-26 21:33:41 Re: Computed index on transformation of jsonb key set
Previous Message Steven Schlansker 2019-04-26 21:25:47 Computed index on transformation of jsonb key set