Andreas Kretschmer <akretschmer@spamfence.net> writes:
> Sam Mason <sam@samason.me.uk> wrote:
>> Based on your query, I think you want a multi-column index---probably on
>> (id,zulu_timestamp).
>>
>> The problem with just having an index on either column is that it's
>> difficult to combine them and PG hence just thinks that it will be
> Since 8.1 PG can do an bitmap index scan using both indexes...
... which produces an unordered result, so it's pretty useless for this
problem. I concur with Sam's suggestion.
regards, tom lane