Naz Gassiep <naz@xxxxxxxx> writes: > If you have an index like this: > CREATE UNIQUE INDEX foo ON tablename (f1, f2); > Is there any value in having independent indicies on f1 and f2 as well > or are they unnecessary? See http://www.postgresql.org/docs/8.3/static/indexes.html particularly sections 11.3 and 11.5 regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
