Re: DISTINCT on jsonb fields and Indexes - Mailing list pgsql-general

From Sankar P
Subject Re: DISTINCT on jsonb fields and Indexes
Date
Msg-id CAMSEaH4X0RTGz54SJx8pXB37O3ngEC0KYS8rATV3R3kmvabA7w@mail.gmail.com
Whole thread Raw
In response to Re: DISTINCT on jsonb fields and Indexes  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-general
>
> There is some work in progress to improve this type of query, but
> it'll be at least PG14 before we see that.

oh okay.

>
> For your version, you might want to look at
> https://wiki.postgresql.org/wiki/Loose_indexscan and try some of the
> proposed solutions from there.

Thanks a lot :)

-- 
Sankar P
http://psankar.blogspot.com



pgsql-general by date:

Previous
From: David Rowley
Date:
Subject: Re: DISTINCT on jsonb fields and Indexes
Next
From: "Peter J. Holzer"
Date:
Subject: Re: Netapp SnapCenter