"Christian Rengstl" <Christian.Rengstl@xxxxxxxxxxxxxxxxxxxxxxxx> writes: > I have a partial index on the expression where not allele_1=allele_2 What is that index's definition *exactly*? No handwaving please, let's see the SQL. Also, what datatypes are these columns? regards, tom lane