Re: Help w/speeding up range queries?

["Luke Lonergan" <llonergan(at)greenplum(dot)com>]

John,

On 10/31/06 3:18 PM, "John Major" <major(at)cbio(dot)mskcc(dot)org> wrote:

> Any advice on how I might be able to improve this situation would be
> very helpful.

I think table partitioning is exactly what you need.

There's a basic capability in current Postgres to divide tables into parent
+ children, each of which have a constraint for the rows inside (in your
case chromosome).  When you query the parent, the planner will exclude child
tables outside of the predicate range.

- Luke