Greetings all.Example table:CREATE TABLE my_table ( id serial PRIMARY KEY, a001 BOOLEAN default 't', a002 BOOLEAN default 'f', a003 BOOLEAN default 't', a004 BOOLEAN default 'f');And these 2 indexes: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.And if it will consider others if the analysis of the first says a seqscan would be better than the index it first considered?Regards,Koen De Groote
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных