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

From Mark Mielke
Subject Re: Combining two bitmap scans out performs a single regular index scan?
Date
Msg-id 475B159D.8000203@mark.mielke.cc
Whole thread Raw
In response to Re: Combining two bitmap scans out performs a single regular index scan?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tom Lane wrote:
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) > (?, ?) 
Cool! That's the ticket. :-)

I guess it would be unnecessary to translate the other two queries into this one for the purpose of planning, eh? :-)

Cheers,
mark
-- 
Mark Mielke <mark@mielke.cc>

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Combining two bitmap scans out performs a single regular index scan?
Next
From: Hervé Piedvache
Date:
Subject: Vacuum full since 15 hours