Re: Performance on JSONB select

From: PegoraroF10 <marcos(at)f10(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Performance on JSONB select
Date: 2019-10-02 20:41:35
Message-ID: 1570048895867-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

ok, my select performed better but I had to create 8 indices to speed up my
query.

I would love to create just one index using GIN(JsonBField jsonb_ops) but
using version 11 I cannot use operators like > and <.

I see on docs that version 12 has jsonpath Filter Expression Elements and
they include > and <. So, the question is, will be possible to have just one
index and use it with "jsonpath Filter Expression Elements ?

--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shital A 2019-10-02 21:00:22 Re: Urgent :: Postgresql streaming replication issue - sync mode
Previous Message Aleš Zelený 2019-10-02 20:19:03 Wall shiping replica failed to recover database with error: invalid contrecord length 1956 at FED/38FFE208