henk de wit <henk53602@xxxxxxxxxxx> writes: > I see, that sounds very interesting too. As you might have noticed, I'm not= > an expert on this field but I'm trying to learn. I was under the impressio= > n that the last few incarnations of postgresql automatically combined singl= > e column indexes for cases where a multi-column index would be needed in ea= > rlier releases. It's possible to combine independent indexes for resolving AND-type queries, but the combination process does not preserve ordering, so it's useless for this type of situation. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend