Group: pgsql.performance


Subject: Combining two bitmap scans out performs a single regular index scan?
From: tgl@sss.pgh.pa.us (Tom Lane)
Date: 12/8/2007 3:46:19 PM
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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend