"Thomas Yagel" <tyagel@yahoo.com> 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