Re: Index filter instead of index condition w/ IN / ANY queries above certain set size

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Danny Shemesh <dany74q(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Index filter instead of index condition w/ IN / ANY queries above certain set size
Date: 2022-11-23 09:22:40
Message-ID: df2e15e9b4d5d72ce2e6a6dc65eb8dc529cee8d8.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 2022-11-23 at 10:49 +0200, Danny Shemesh wrote:
> I'm trying to understand when the planner decides to use an index condition vs an index filter

I am not sure what you mean by "index filter".

If you could send the result of EXPLAIN (ANALYZE, BUFFERS) for the queries,
that would be most useful.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nikolas Hanry 2022-11-23 10:22:34 Fwd: Postgre und GIS Umstellung von MD5 auf SCUM SHA 256
Previous Message Danny Shemesh 2022-11-23 08:49:25 Index filter instead of index condition w/ IN / ANY queries above certain set size