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

From PegoraroF10
Subject Re: Performance on JSONB select
Date
Msg-id 1570528300014-0.post@n3.nabble.com
Whole thread Raw
In response to Re: Performance on JSONB select  (Michael Lewis <mlewis@entrata.com>)
List pgsql-general
Sorry, I told you that the status was always populated but not, I need that
filter for the index because not all records are using that json structure.
When json is not null then yes, Status is always there. 
I have maybe 20 or 25% of records having json populated, so, I really need
that filter.

Yes, that solution is fine. Selectivity is fine, speed is fine and the index
is "almost dynamic"



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



pgsql-general by date:

Previous
From: "Arnaud L."
Date:
Subject: Re: psql \copy hanging
Next
From: Timmy Siu
Date:
Subject: GPS coordinates problem