Re: Help w/speeding up range queries?

John,

On 10/31/06 3:18 PM, "John Major"  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