Документ взят из кэша поисковой машины. Адрес оригинального документа : http://vo.astronet.ru/wiki/q3c-2011
Дата изменения: Unknown
Дата индексирования: Sat Apr 9 22:46:52 2016
Кодировка:

Поисковые слова: arp 220
q3c-2011 [SAI Virtual Observatory - Wiki]

Title: Efficiently handling spherical data in Postgres

Authors: O.Bartunov, S.Koposov, S.Karpov

Abstract: Spherical data appear in a lot of problems in modern science and technology, ranging from geoinformational systems to astronomical catalogues. Efficient handling of such data in Postgres is necessary, and Postgres do have support for it, though not in core, through its ability to define fully indexable custom data types and functional indices.

In the talk we review existing implementations of spherical data support available for Postgres in Q3C, pgSphere, PostGIS etc and compare its performance on the range of use-cases - from bulk loading to range queries to live update. We demonstrate how different indices used (B-tree in Q3C, GiST+R-tree in pgSphere and PostGIS) help to optimize data handling for a specific problem in hands.

q3c-2011.txt · Last modified: 2011/01/18 17:05 by karpov
Back to top
SAI VO | Astronet | SAI MSU | Legal Information
RFBR