Re: Help optimizing a slow index scan

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sat, Mar 18, 2006 at 11:50:48 +0300,
  Oleg Bartunov <oleg@xxxxxxxxxx> 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.


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux