Re: Help w/speeding up range queries?

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Help w/speeding up range queries?
Дата
Msg-id 1162465187.3587.294.camel@silverbirch.site
обсуждение исходный текст
Ответ на Help w/speeding up range queries?  (John Major <major@cbio.mskcc.org>)
Список 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 по дате отправления:

Предыдущее
От: "Marcin Mank"
Дата:
Сообщение: Re: Help w/speeding up range queries?
Следующее
От: "Nikolay Samokhvalov"
Дата:
Сообщение: Query plan for "heavy" SELECT with "lite" sub-SELECTs