Re: Help optimizing a slow index scan - Mailing list pgsql-performance

From Bruno Wolff III
Subject Re: Help optimizing a slow index scan
Date
Msg-id 20060318150019.GA8398@wolff.to
Whole thread Raw
In response to Re: Help optimizing a slow index scan  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-performance
On Sat, Mar 18, 2006 at 11:50:48 +0300,
  Oleg Bartunov <oleg@sai.msu.su> wrote:
> I may be wrong but we in astronomy have several sky indexing schemes, which
> allows to effectively use classical btree index. See
> http://www.sai.msu.su/~megera/oddmuse/index.cgi/SkyPixelization
> for details. Sergei Koposov has developed Q3C contrib module for
> PostgreSQL 8.1+ and we use it with billiard size astronomical catalogs.

Note that Earth Distance can also be used for astronomy. If you use an
appropiate radius, distances will be in degrees.

pgsql-performance by date:

Previous
From: Antoine
Date:
Subject: n00b autovacuum question
Next
From: "NbForYou"
Date:
Subject: database model tshirt sizes