On Dec 26, 2010, at 11:24 AM, Tom Lane wrote:
If you're doing interval queries enough to worry about having an index
for them, you really want an indexing structure that is designed to do
interval queries efficiently.
BTW, one way to accomplish that is to transform your data into geometric
Marti Raudsepp ma...@juffo.org writes:
On Thu, Dec 23, 2010 at 22:52, Tom Lane t...@sss.pgh.pa.us wrote:
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
On Thu, Dec 23, 2010 at 22:52, Tom Lane t...@sss.pgh.pa.us wrote:
Ben midfi...@gmail.com 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
hello --
i have a schema similar to the following
create table foo (
id integer not null,
val integer not null,
s integer not null,
e integer not null
);
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
Ben midfi...@gmail.com 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
On Dec 23, 2010, at 12:52 PM, Tom Lane wrote:
Ben midfi...@gmail.com 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;