Re: How does postgres behave if several indexes have (nearly) identical conditions?

[David G. Johnston]

On Wednesday, September 8, 2021, Koen De Groote <kdg....@gmail.com> wrote:

>
>
> create index index_001 on my_table using btree (a001,a002,a003) where
> a001=true and a002=false;
>
> create index index_002 on my_table using btree (a003) where a001=true and
> a002=false;
>
> Now take this query:
>
> select * from my_table where a001=true;
>
> Which index will postgres pick? I'm wondering how postgres goes about
> picking an index to consider.
>

Neither…since neither partial index condition is present in the where
clause of the query.

David J.