Postgres Pro
Downloads
Home   >   mailing lists

Re: Combining two bitmap scans out performs a single regular index scan? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Combining two bitmap scans out performs a single regular index scan?
Date
Msg-id 15505.1197146779@sss.pgh.pa.us
Whole thread Raw
In response to Combining two bitmap scans out performs a single regular index scan?  (Mark Mielke <mark@mark.mielke.cc>)
Responses Re: Combining two bitmap scans out performs a single regular index scan?
List pgsql-performance
Tree view 
Mark Mielke <mark@mark.mielke.cc> writes:
> To find records after a certain time, I must do one of:
>     select * from icpric where audtdate > ? or (audtdate = ? and
> audttime > ?)

In recent releases (at least 8.2, don't remember about 8.1), a row
comparison is what you want:

    WHERE (auddate, adttime) > (?, ?)

            regards, tom lane

pgsql-performance by date:

Previous
From: Mark Mielke
Date:
Subject: Combining two bitmap scans out performs a single regular index scan?
Next
From: Mark Mielke
Date:
Subject: Re: Combining two bitmap scans out performs a single regular index scan?