Benjamin Arai <me@xxxxxxxxxxxxxxxx> writes: > It appears that the ORDER BY rank operation is the slowing factor. > If I remove it then the query is pretty fast. Is there another way > to perform ORDER BY such that it does not do a sort? I think you misunderstood: it's not the sort that's slow, it's the computation of the rank() values that are inputs to the sort. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match