>I am afraid PostgreSQL is not smart enough to rewrite query with "or" into
>two separate index scans. There is no way to improve the query
>significantly without rewriting it.
>Note: for this case indices on (datecol), (cr) and (db) are not very
Thank you very much.
I added you indexes to db and re-write query.
Now it runs fast.