Andreas Kretschmer <[email protected]> writes:
> Sam Mason <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
