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