On Mon, 2007-03-19 at 14:31 -0400, Tom Lane wrote: > Jeff Davis <pgsql@xxxxxxxxxxx> writes: > > I have two indexes defined on "syslog_p": > > > "syslog_p_severity_ts_idx" btree (severity, ts) > > "syslog_p_ts_where_severity_1_idx" btree (ts) WHERE severity = 1 > > > The planner chooses what looks to me like a very strange plan for this > > query: > > => explain analyze select * from syslog where severity=1; > > The attached crude hack makes it not do that, but I wonder whether it > won't prevent use of bitmap AND in some cases where we'd rather it did > use an AND. Want to try it out? > The patch you provided appears to work perfectly. Thanks! Regards, Jeff Davis
