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
Re: Performance on JSONB select |
| Список | 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 по дате отправления: