"Andrus" <eetasoft@xxxxxxxxx> writes: > Why Postgres 8.1 does not use makse_kuupaev_idx index in the following query > ? Because it doesn't help --- the system still has to do the sort. You'd need a two-column index on both of the ORDER BY columns to avoid sorting. regards, tom lane
