Re: DISTINCT on jsonb fields and Indexes

From: Sankar P <sankar(dot)curiosity(at)gmail(dot)com>
To: David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: DISTINCT on jsonb fields and Indexes
Date: 2020-06-22 07:21:32
Message-ID: CAMSEaH4X0RTGz54SJx8pXB37O3ngEC0KYS8rATV3R3kmvabA7w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2020-06-22 11:01:13 Re: Netapp SnapCenter
Previous Message David Rowley 2020-06-22 07:13:33 Re: DISTINCT on jsonb fields and Indexes