"Edmundo Robles L." <erobles@xxxxxxxxxxxxxx> writes: > I have two index with a same field into them like this: > create index numberfail on Events (numberfail); > and > create index failtype on Events (numberfail,eventtype); > then i ran explain analyze and always took the numberfail index but i wish the failtype index; Uh, why? If you have the smaller index available it's hard to imagine any sane reason not to use it. > I though maybe if i delete the index numberfail could works, but i don't know if the another program > will fail if the numberfail index does'nt exists. No, you can drop that one if you want to. You might care to read the fine manual about index design: http://www.postgresql.org/docs/8.3/static/indexes.html regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
