Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 0F46F9FA274 for ; Thu, 2 Nov 2006 07:00:21 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 09653-06 for ; Thu, 2 Nov 2006 07:00:12 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail01.enterprisedb.com (mail01.enterprisedb.com [63.246.7.168]) by postgresql.org (Postfix) with ESMTP id 663B19F976E for ; Thu, 2 Nov 2006 07:00:12 -0400 (AST) thread-index: Acb+bhHsSIUE6vizR9u9y9VTJHzJvA== Received: from [192.168.0.31] ([82.133.64.220]) by mail01.enterprisedb.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 2 Nov 2006 06:00:12 -0500 Subject: Re: Help w/speeding up range queries? Content-Class: urn:content-classes:message Importance: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2757 From: "Simon Riggs" To: "John Major" Cc: In-Reply-To: <4547D9CE.2040705@cbio.mskcc.org> References: <4547D9CE.2040705@cbio.mskcc.org> Content-Type: text/plain; charset="iso-8859-1" Date: Thu, 02 Nov 2006 10:59:47 +0000 Message-ID: <1162465187.3587.294.camel@silverbirch.site> MIME-Version: 1.0 X-Mailer: Evolution 2.6.0 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 02 Nov 2006 11:00:12.0625 (UTC) FILETIME=[11DDE410:01C6FE6E] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/19 X-Sequence-Number: 21789 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