Andreas Kretschmer <akretschmer@xxxxxxxxxxxxx> writes: > Sam Mason <sam@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
