Re: Performance on JSONB select - Mailing list pgsql-general

From PegoraroF10
Subject Re: Performance on JSONB select
Date
Msg-id 1570297030805-0.post@n3.nabble.com
Whole thread Raw
In response to Re: Performance on JSONB select  (Fabrízio de Royes Mello <fabrizio@timbira.com.br>)
Responses Re: Performance on JSONB select
List pgsql-general
No, no, no, partial index is the where clause of it and I´m not talking about that.
I´m talking about datevalue, which will be used one or another, depending on status value

This record iindex will be status and datevalue from "visitadescartada" object
{
  "status": "visitadescartada",
  "atribuido": {"datevalue": "2019-09-05 14:47:11"},
  "visitadescartada": {"datevalue": "2019-09-12 11:47:17"},
  "digitacaodescartada": {}
}

And here the index record will be status and datevalue from "atribuido" object
{
  "status": "atribuido",
  "atribuido": {"datevalue": "2019-09-05 14:47:11"},
  "visitadescartada": {"datevalue": "2019-09-12 11:47:17"},
  "digitacaodescartada": {}
}

Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: bhargav kamineni
Date:
Subject: Re: PMChildFlags array
Next
From: Miles Elam
Date:
Subject: Re: Event Triggers and Dropping Objects