"Thomas Yagel" <[EMAIL PROTECTED]> writes:
> Right now the index that I have on timestamp is not used because the Primary
> Key(ID) index is chosen for ordering. If I place a multicolumn index on
> (timestamp, id) will that index be able to filter the timestamp and still be
> used for returning the ordered IDs?
You'd need to do that and also say "ORDER BY timestamp, id" not just
"ORDER BY id".
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
