Andreas Kretschmer <akretsch...@spamfence.net> writes:
> Sam Mason <s...@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
