Re: Performance on JSONB select

Поиск
Список
Период
Сортировка
От PegoraroF10
Тема Re: Performance on JSONB select
Дата
Msg-id 1570048895867-0.post@n3.nabble.com
обсуждение исходный текст
Ответ на Re: Performance on JSONB select  (Michael Lewis <mlewis@entrata.com>)
Ответы Re: Performance on JSONB select  (PegoraroF10 <marcos@f10.com.br>)
Re: Performance on JSONB select  (PegoraroF10 <marcos@f10.com.br>)
Список 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



В списке pgsql-general по дате отправления:

Предыдущее
От: Aleš Zelený
Дата:
Сообщение: Wall shiping replica failed to recover database with error: invalidcontrecord length 1956 at FED/38FFE208
Следующее
От: Shital A
Дата:
Сообщение: Re: Urgent :: Postgresql streaming replication issue - sync mode