Re: Selectivity and row count estimates for JSONB columns

2021-10-20 Thread Joel Perren
some jsonb columns but not others? I've looked at my CREATE TABLE scripts and they are identical. We have the database deployed in another environment and this issue reoccurs there too. Any help would be appreciated :) Thanks Joel On Wed, Oct 20, 2021 at 3:56 PM Joel Perren wrote: > Hi

Selectivity and row count estimates for JSONB columns

2021-10-20 Thread Joel Perren
Hi all I have a Postgres/PostGIS database with two separate database tables each of which has the following column structure: - identifier (text) - geometry (geometryz,27700) - properties (jsonb) I have created a GIN index (jsonb_path_ops) over the properties column on both tables. As I underst