On Thu, Dec 23, 2010 at 22:52, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Ben <midfield@xxxxxxxxx> writes: >> i have a schema similar to the following > >> create index foo_s_idx on foo using btree (s); >> create index foo_e_idx on foo using btree (e); > >> i want to do queries like > >> select * from foo where 150 between s and e; > > That index structure is really entirely unsuited to what you want to do, > so it's not surprising that the planner isn't impressed with the idea of > a bitmap AND. Why is it unsuited for this query? It expands to (150 < s AND 150 > e) which should work nicely with bitmap AND as far as I can tell. Regards, Marti -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
