Re: Help w/speeding up range queries?

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "John Major" <major(at)cbio(dot)mskcc(dot)org>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Help w/speeding up range queries?
Date: 2006-11-02 10:59:47
Message-ID: 1162465187.3587.294.camel@silverbirch.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, 2006-10-31 at 18:18 -0500, John Major wrote:

> #I am a biologist, and work with large datasets (tables with millions of
> rows are common).
> #These datasets often can be simplified as features with a name, and a
> start and end position (ie: a range along a number line. GeneX is on
> some chromosome from position 10->40)

Do you know about www.biopostgres.org ?

I believe they provide some additional indexing mechanisms for just this
type of data.

--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Nikolay Samokhvalov 2006-11-02 11:07:19 Query plan for "heavy" SELECT with "lite" sub-SELECTs
Previous Message Marcin Mank 2006-11-02 10:54:57 Re: Help w/speeding up range queries?