Re: Help w/speeding up range queries? - Mailing list pgsql-performance

From Simon Riggs
Subject Re: Help w/speeding up range queries?
Date
Msg-id 1162465187.3587.294.camel@silverbirch.site
Whole thread Raw
In response to Help w/speeding up range queries?  (John Major <major@cbio.mskcc.org>)
List 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



pgsql-performance by date:

Previous
From: "Marcin Mank"
Date:
Subject: Re: Help w/speeding up range queries?
Next
From: "Nikolay Samokhvalov"
Date:
Subject: Query plan for "heavy" SELECT with "lite" sub-SELECTs