Postgres Pro
Downloads
Home   >   mailing lists

Re: Index filter instead of index condition w/ IN / ANY queries above certain set size - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Index filter instead of index condition w/ IN / ANY queries above certain set size
Date
Msg-id df2e15e9b4d5d72ce2e6a6dc65eb8dc529cee8d8.camel@cybertec.at
Whole thread Raw
In response to Index filter instead of index condition w/ IN / ANY queries above certain set size  (Danny Shemesh <dany74q@gmail.com>)
Responses Re: Index filter instead of index condition w/ IN / ANY queries above certain set size  (Danny Shemesh <dany74q@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Danny Shemesh
Date:
Subject: Index filter instead of index condition w/ IN / ANY queries above certain set size
Next
From: Nikolas Hanry
Date:
Subject: Fwd: Postgre und GIS Umstellung von MD5 auf SCUM SHA 256